Combo box help.

[pfm721]

This is an easy one, but I can't seem to get it to work. I have a form with a
combo box on it to display a Vendor's name. When I look up a record I need to
box to populate with the current vendor. If I then click on the box I want it
to show all availble vendor's in case I need to change vendor's at a
different time. Table structure is as follows. Users pull records by
searching VetSSN.

tblVet
VetSSN (pk)
Consult#

tblConsult
Consult# (pk)
VendorID

tblVendor
VendorID (pk)
VendName
VendCity
VendState

 

[John W. Vinson]

This is an easy one, but I can't seem to get it to work. I have a form with a
combo box on it to display a Vendor's name. When I look up a record I need to
box to populate with the current vendor. If I then click on the box I want it
to show all availble vendor's in case I need to change vendor's at a
different time. Table structure is as follows. Users pull records by
searching VetSSN.

tblVet
VetSSN (pk)
Consult#

tblConsult
Consult# (pk)
VendorID

tblVendor
VendorID (pk)
VendName
VendCity
VendState

I'm confused. What is actually on your Form? A combo box based on tblVendor?
What's the Form's Recordsource? What are the real-life English language (not
database relationship) connections between the three tables?

 

[pfm721]

john,

The forms record source is tblConsult

The user is using a search function on another form to display Consults
related to a particular SSN. When the user double clicks on a consult number
the form pops up with boxes displaying all of the information from
tblconsult. I would also like to include the vendor information on this form
for the vendor related to the VendorID. Ideally I would make VendorID not
visible and just have the Vendor Name show up. Sometimes it is necessary to
change the Vendor for a particular consult. That being said I would like the
Vendor name to show in a combo box and the user to be able to click and see
the whole list of vendors in the system so they can select a new vendor.

Patrick