Combo Box for locating records

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

Guest

Hi
I am attempting to create a combo box to locate records in a form.
According to my instructions (and I've done it this way before), when I
click on the Combo Box icon and into the form header area three options will
come up and I should select the last one ("Find a record on my form based on
the value I selected in my combo box")

My problem is that in my equipment database (it's the only one that does
this), when I click on the Combo Box icon in the form header area, it only
comes up with the first two options!

How do I create a combo box to locate my records?!!

Thanks

Kat
 
Hi
I am attempting to create a combo box to locate records in a form.
According to my instructions (and I've done it this way before), when I
click on the Combo Box icon and into the form header area three options will
come up and I should select the last one ("Find a record on my form based on
the value I selected in my combo box")

My problem is that in my equipment database (it's the only one that does
this), when I click on the Combo Box icon in the form header area, it only
comes up with the first two options!

How do I create a combo box to locate my records?!!

Thanks

Kat
Click to expand...
That usually means you have not bound a query/table to the form yet.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
What do you mean by that? How do I bind the query?
Sorry to be so clueless.

Kat
Click to expand...

You need to set the RecordSource on the Data tab of the properties sheet for the
form.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Thankyou! :)

RuralGuy said:
You need to set the RecordSource on the Data tab of the properties sheet for the
form.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box filter 1
Combo Box and First Record 5
Combo Box Question 4
Combo Box 3
how to show data only from selected combo boxes ? 0
Combo Box Problems 1
Combo box question 7
Combo box look up option on form missing 2

Back
Top