Doing a search in a blank form

[Access_Novice]

On my form, I click Add New record, in order to clear out all existing values. Then I type a last name in the last name field and click the Find button. I get an error message saying I must enter a gymnastID. Undoubtedly this is because gymnastID is the primary key and Access thinks I am trying to enter a new record, when I am not. I would like to be able to do a search on a clean form just like I can do with Deltek GCS Premier.

Is there a way to circumvent this problem?

[June7]

This is a bound control so cannot type search criteria into it. That would require an unbound control and some code.

Could Right Click in the control and use the intrinsic filter/search utility.

[Missinglinq]

...I click Add New record...

...Access thinks I am trying to enter a new record, when I am not...

Of course you are! Adding a New Record is what the Add New Record button does! June7 has given you the simplest approach, or you could use a Combobox with the "Find a record based on the value I selected in my combobox option, or a Textbox and Command Button utilizing code like this Combobox option uses.

Linq ;0)>