Search option in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that will allow me to search an table and bring back the information on a form

The two tables i am trying to search are fixtures table and a furniture table
both of these tables have a pk called roomID

how will i go about doing this?
 
Hi

Not sure I have enough info to go on here.... Is it a one-to-one relationship? I gather your form is based on 2 underlying tables then. I got this to work by first creating a query that contains all the info that you will want to see on your form
Then base a form on this query
Insert a Combo box from your toolbox onto the detail section of your form in design view (make sure the wizad button is on).
Choose the third option "Find a record based on the value I selected in my combo box"
Select the field/s that you want in the combo box, in other word what it is you want to search by
Complete the wizard and give it a swing!

Hope it works - if not let me kno

Davi
 
Back
Top