Searching for data

[Carolyn]

I created an Access data base and need to do a
search/find for various field information and I would
like to add those commands to my switchboard.

The fields are as follows:

Work Order Number
Lot Number
PO Number
Subdivision

I want to set it up so I can add a search command on the
swithboard to find a specific field and the record will
appear on the screen.

Thanks for all you help.

 

[Bob barnes]

Use an unbound ComboBox to display FieldNames you want to search
Also, an unbound textbox to enter "ab" if that field has "..ab.." in it

Use a SQL statement using "Like" to get any resulting Record
which can be displayed in an unbound ComboBox

HTH - Bob

 

[Carolyn]

Thanks for responding Bob. However, I am new to this and have know idea of what you are referring to.

 

[Bob Barnes]

Do you want to try some sample code?

 

[Carolyn]

Yes please.

I have been searching for sample codes all day without success.

Thanks

 

[Bob Barnes]

Carolyn - I just checked your answer. Please let me know you receive this by sending a reply to me at both of these

(e-mail address removed) --- & -- (e-mail address removed)

I have the code where I will be tomorrow. If you understand how to use unbound ComboBoxes & textboxes, plus how t
DoCmd.ApplyFilter, you should be able to understand the code I will send you tomorrow

I use unbound Forms whenever I can, & they require more Programming (but it works better IMHO). The code I'll send wil
be for bound Forms

Bob