Search form from scratch

[al718]

Hi, im really new to access and although i have seen examples of search forms, i have no idea how to make one myself

from what i understand, it looks like it is possible to create a list box which looks its values up from a text box on the same form

what are the basic steps to creating search forms?

please go easy on me and explain if it takes a lot of code



thanks a lot

 

[mlopes1]

Could you give a little more information about this? Are you trying to search through a form that is also where you enter new records? Or are you creating a whole seperate form that is only used for searching? Either way can be done, but it changes how to approach it just a little bit.

 

[al718]

i'm trying to make a form that is used only for search records

the record entry forms are done and i wanted to add a form that would allow you to search through to find records

 

[mlopes1]

OK, then what you want to do is:

1. Make the record source of the "search form" be whatever table the "entry form" stores your records in.

2. Add all the fields to the form that you eventually want to view of the "found record".

3. To make this really easy with minimal code, make sure the Wizard is turned on.

4. Add a combo box.

5. when the wizard pops up, select the 3rd option which says "Find a record on my form... etc"

6. Choose what field you want to search by

7. Go through the rest of the wizard and then test it out.

That should do it. You may need to change some settings of your form to hide record selectors and other small tweaks. But overall, doing the above will search through the record source table, find the selected value = to the combo box value, and then display its information in the fields you added in step 2.

Hope that helps,

Marco


...also, if you want to see the underlying code, you can look on the combo boxes "after update" event.

 

[al718]

thanks marco, that does help a bit