combo box no record source

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

Guest

Hi please help! I have a "tours" table in which there is a field for pick up
points and times. I'm trying to get it so that the data for this field can be
inputted through a user friendly form, I'm unsure how to go about this
because I've been trying to do it using a combo box where the data can be
entered but obviously there is no record source. I need the "booking
information" form to be able to retrieve whichever pickup point/time the
customer selects from each tour. Please help...I've tried various VB coding
but to no avail (it allows data entry but there isn't anything already in the
list to match it to).

Many thanks in advance if you can help!

Michelle
 
Hi please help! I have a "tours" table in which there is a field for pick up
points and times. I'm trying to get it so that the data for this field can be
inputted through a user friendly form, I'm unsure how to go about this
because I've been trying to do it using a combo box where the data can be
entered but obviously there is no record source. I need the "booking
information" form to be able to retrieve whichever pickup point/time the
customer selects from each tour. Please help...I've tried various VB coding
but to no avail (it allows data entry but there isn't anything already in the
list to match it to).

Many thanks in advance if you can help!

Michelle
Click to expand...

You've lost me.

If you don't have the information anywhere in your database, how can
it be selected in a combo box?

If you do have the information in your database, what's to stop you
from using it as the RowSource (not Recordsource, that applies to
Forms) of your combo box?

What tables do you have, and how are they related? Don't assume that
we can see your database or that we're experts in the tour-booking
business...

John W. Vinson[MVP]
 
Back
Top