I have a form linked to a query. The form has a combo box to search for by claim #. I would like this form to open with no previous record values showing. I do not want to the form to be set as data entry. Is there a way to do this?
I have a form linked to a query. The form has a combo box to search for by claim #. I would like this form to open with no previous record values showing. I do not want to the form to be set as data entry. Is there a way to do this?
If you do not want the form's Data Entry property to = Yes then I believe the only option left is to not have it bound. Why not place your combo on a main form that is unbound and use a subform to link to your query? You could use the .Visible property to hide your subform and .Recordsource to adjust the recordsource.
Or you could simply open the Form to a New Record:
Code:Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub
Linq ;0)>
I see. I suppose that does avoid setting the form's property as data entry. There could be advantages/distinctions in doing it this way.
Sure; it just depends on your needs! And since the OP is using a Combobox to retrieve Records, he cannot set Data Entry to Yes. With that setting, the Record Source of the Form does not contain any previously existing Records, only Records entered during that session.
Your suggested approach was just fine, it just involves a lot of work for a newbie.
Linq ;0)>
I was not considering why the OP did not want to employ Data Entry. Perhaps some sdditional property settings and code can prevent an accidental addition and or saving of a record.