Form Combo box has no data upon opening

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

Guest

I created a vendor combo box on my form. When I open the form, there is no
data in the vendor name field (all other fields are populated i.e. address,
city) until I chose a vendor from the drop down list. How do I get this data
into this field before a selection is made?
 
What value do you want to show in the ComboBox? If the cbo is bound to a
field in the form's RecordSource, then it would have a value. That means the
cbo would need to have the ControlSource completed on the data tab of the
property sheet for the cbo. If it needs to be unbound because it is a
navigation tool then again, what value should be displayed?
 
When the user opens the form, I would like for read-only data to be viewed
beginning with the first record in the vendor table (Vendor Name field). If
the user would like to view a different vendor, they should select the chosen
vendor from the combo drop-down list which would then update the remaining
fields with the form with the chosen vendor's data.
 
So your form is to display Vendor information and the cbo is to select a
vendor? You said read-only display of the data, do you ever want the user to
be able to alter the data in this form?
When the user opens the form, I would like for read-only data to be viewed
beginning with the first record in the vendor table (Vendor Name field). If
the user would like to view a different vendor, they should select the chosen
vendor from the combo drop-down list which would then update the remaining
fields with the form with the chosen vendor's data.
What value do you want to show in the ComboBox? If the cbo is bound to a
field in the form's RecordSource, then it would have a value. That means the
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
 
Back
Top