Doing a Query, doing a form

[Sisko]

Is it possible to run a query, in the format of a form?

All I need is a query, in the format of a form which will search a car database on the car registration number and or its make.

Now, I know how to set up a query to do this, but what I need to know, is it possible to set it up to run as a form, and then use that form to type in something to look for? if that makes sense.

cheers guys

 

[jeremypaule]

yes this is possible. You can do it from a subform, or search 'filter' on this forum and that should help you out.

 

[battenberg]

1. create your query.
2. use the form wizard to generate a form based on that query
3. use the toolbox to put a command button on the form to create a 'search function'
4. if you want to be a bit clever and regnumber is the usual search criteria, add

   regnumber.setfocus*

   to the forms 'on load' or 'on current' event. That will ensure that when you load the form and click the search button it will default to the regnumber field ready to do the search.

*where regnumber is the registration number field.