Finding Data 1

[esu4edp]

I'm building a database for my police department.&nbsp;&nbsp;We are entering names, address, etc. for our jurisdiction as a start.&nbsp;&nbsp;On a form I have created a button.&nbsp;&nbsp;When the user clicks on that button, I want a box to come up and ask the user to enter an address.&nbsp;&nbsp;Then I want it to search for anything matching that address and display the information entered from the tables.<br><br>How do I do this?<br><br><A HREF="mailto:esu4edp@netpluscom.com">esu4edp@netpluscom.com</A>

 

[advpay]

base it on a query on the table you are using...and in the Criteria field of the field you want to search put...<br><br>Like [Enter Address] & &quot;*&quot;

 

[elizabeth]

Or you might want to extend it to <br>Like &quot;*&quot; & [Enter street name or partial name] & &quot;*&quot;<br>Or, if you only care about exact matches, you can just use<br>[enter the street adress] as the criteria.<br>In either case, use a combo box for the address.

 

[esu4edp]

Thanks for the help it works perfectly.