search Function In A Form

[Guest]

Im trying to build a search funtion in a form. The function should search
for data in the Equipment_Table and then show the results. The
Equipment_Table has the following fields:

Product Type
It Asset No - unique value
Manufacturer
Model Number
Serial Number - unique value

I want to be able to search by either the IT Asset No or the Serial Number.
After the search I want the form to display all the fields for each record,
i.e, Product Type, IT Asset No, Manufacturer, Model Number and Serial Number.
I'm not really sure where to start with this as I am quite new to Access.

Thanks for the help

tommy

 

[Guest]

Check this link on "Using a Microsoft Access Combo Box to Search for a Record"

http://www.databasedev.co.uk/combo_box_search.html

It will be a good start

 

[Allen Browne]

Tommy, see if this meets your needs:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

You don't have to be a programmer to implement this, as it is a copy'n'paste
solution. Copy the code, and set one property for your form.

 

[Guest]

Thanks, got that working now.

Tommy

 

[Craig A. Darville]

Allen:

I used your code "AppFindAsUType" and find it very useful. Thank you for
taking the time to share. I will be adding it to my toolbox.

In the function FindAsUTypeChange, if the text box has focus when you type
text which results in no matches you are unable to backspace and show the
previous results. This becomes an issue if you mis-type and then try to
correct by backspacing. To see your previous results, you must reselect the
filter field from the combo box and retype your filter characters again.

What I find is if the strText is not null and you apply the form filter, the
underlying recordset would requery. If this re-query action results in "no
records" when we try to put the focus back on the text box an error results
(which you handle in a Case 2185.

By jumping out of the function, it does not allow the text box to take a
back space character and display the previous filtered items.

Has anyone expressd this concern?