SEARCH FORM HELP!

  • Thread starter Thread starter tdauzat via AccessMonster.com
  • Start date Start date
T

tdauzat via AccessMonster.com

Hello All!!,

I need some programming help. I have a address search form I have created,
in the header section there are 4 text boxes that include the street
number, direction, street name, and street type, and search button.

Below in the detail I have 9 text boxes that I would like to include the
results of the search that are listed in the table or query. Anyone that
can provide a little help for this would be greatly appreciated.
 
Let's call your form MySearchForm. Create a query that contains the fields
the 9 textboxes are bound to. Presumably this includes, Street Number,
Direction, Street Name and Street Type. Enter this expression in the Street
Number criteria:
Forms!MySearchForm![Stret Number] Or (Forms!MySearchForm![Stret Number] Is
Null)
Add a similar expression in the criteria of the other three fields.
Put the following code in the Click event of the Search button:
Me.Requery

You can now enter search criteria in one or more of the textboxes in the
Header. When you click the Search button, your form will display all the
records that match the criteria you entered. If you want to change one or
more criteria, do so and click the Search button again and the records that
match the new search criteria will be in your form.
 
Back
Top