I need a search box to select and open forms and reports

[Steve Taber]

I have self taught myself to build databases and I have a great one going for
work, but I need a search box to select and open forms and reports based on
records already in the system. I'm currently using a query with a [Enter
Date] command before opening the forms, and then scrolling through all of the
forms under that date. I have a search box on a form that I borrowed from one
of the books I used to train myself, but I can't get it to work. Please help.
This one thing will help me to finish my database.
Thanks,
Steve

 

[John Vinson]

On Tue, 18 Jan 2005 08:33:04 -0800, "Steve Taber" <Steve

I have self taught myself to build databases and I have a great one going for
work, but I need a search box to select and open forms and reports based on
records already in the system. I'm currently using a query with a [Enter
Date] command before opening the forms, and then scrolling through all of the
forms under that date. I have a search box on a form that I borrowed from one
of the books I used to train myself, but I can't get it to work. Please help.
This one thing will help me to finish my database.
Thanks,
Steve

Rather than a criterion [Enter Date] try a criterion like

[Forms]![YourFormName]![txtDate]

to use the data entered in the *UNBOUND* textbox named txtDate on the
(preferably unbound) form YourFormName. You can then put a button on
YourFormName to open a data display form based on this Query.

John W. Vinson[MVP]