Searching in a form

[seanog2001]

I was looking for help to find out how i would put a search facility on a form

Ive written a query with a parameter where you input a persons name in order to find it in a table

the porblem is when i base a from on this query it brings up the parameter asking me to enter the name, the query works fine it does what i want it to do.

i want to be able to open the form and if i need the facility to enter a name an d bring the details up in a sub form

any ideas?

 

[mea00jmf]

May help

A very basic way to do this would be to ceate a copy of yourquery without the parmeter and create new form based on this query. When opened this would return all the records in the query. To search on a parameter you could have a command button that closes the form you are in and opens your orginal form (via a macro), thus prompting for the parameter.

Very simple and I'm sure unnecessarily long winded but it will give you what you want without having to learn any new tricks!

Hope this makes sense and is of some help.

 

[seanog2001]

A very basic way to do this would be to ceate a copy of yourquery without the parmeter and create new form based on this query. When opened this would return all the records in the query. To search on a parameter you could have a command button that closes the form you are in and opens your orginal form (via a macro), thus prompting for the parameter.

Very simple and I'm sure unnecessarily long winded but it will give you what you want without having to learn any new tricks!

Hope this makes sense and is of some help.

that sorted it for the moment i can use it til i try and find out how to do a search cheers!!