Searching for data

  • Thread starter Thread starter Carolyn
  • Start date Start date
C

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.
 
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
 
Thanks for responding Bob. However, I am new to this and have know idea of what you are referring to.
 
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
 
Back
Top