Vishal has attended:
Access Intermediate course
Access Advanced course
Form
How do I turn a Form in to a Search tool once ive created it?
My form is liked to a Query, so I would like to be able to update the Query without changing the Forms search ability.
RE: Form
Hi Vishal,
I think that you could create a combo box on your form, (in design view) from the Toolbox select the combo-box button, and click in some spare space on your form. Decide which field in your query you wish to search in, from the options on the first page choose "Find a Record on my form based on the value I selected in my combo box" Follow the instructions, and when finished, change back to Form View and click the drop down arrow, make your choice and your form should change to the selected criteria. Hope that helps!
RE: Form
Thanks for the help, it worked fine, but now that ive dont this i would also like to be able to use the form on its own without having to open access. that why someone can search for data without having to know how to use access.
RE: Form
Hi Vishal,
I think you will find that you will have to open Access to use the form, however if you go to Tools, Startup and have a look at some of the options available, you will find an option to open a form when you open Access. Or you can create an autoexec macro (a macro named autoexec) which will run as you open the database and this macro can be actioned to open the form, dont forget to Maximise or you will see all the "gubbins" below the window. May I suggest that you create a copy of your database before switching off some of the functions, as it can be difficult to get some of them back. Further to this, you would have to allow administrators access in order to populate/edit the database.
