Search Function In Forms

G

GC

When I want to find a record in a form I want to open the search function to
search the table, and match would be "any part of field"
 
R

Rli

in tools>options>edit/find set General search
this will give 'any part of the field' as default when you start a search.

To start the search dialog automaticaly you can give an on_load event on the
startup form with:
DoCmd.RunCommand (acCmdFind)
 
G

GC

Thanks
--
Gary C


Rli said:
in tools>options>edit/find set General search
this will give 'any part of the field' as default when you start a search.

To start the search dialog automaticaly you can give an on_load event on the
startup form with:
DoCmd.RunCommand (acCmdFind)
Click to expand...
 
A

alexasha

DoCmd.RunCommand (acCmdFind) that works great. I placed it in "on key down"
for name field and it would bring search box for the whole table (form).

Is there any way to specify search field. I would like to search particular
field (column). I know I can change it in search box, but it would be nice to
do without it.
 
Top