Find

[sir_dan_mitchell]

hey, I want to have a find facility in my video database. but if the user clicks directly on find it find in the "Customer ID" or "Video ID". Is there a way I can take it straight to Surname and video name?

 

[jwindon]

Consider putting a command button on your form that will "FIND" using a query. The command button should be set to run this query.

In your query, set your criteria under the Surname (for customers) to Like([Enter Surname]).

This is a quick way to do it. You may wish to consider other find options that can be executed based off unbound forms used specifically to "find" things. In that case, the criteria of the query is set to something such as Like(Forms!SearchFormName!UnboundControlNameOnSearchForm)

Good luck!