Form Combo box has no data upon opening

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

babysteps - 19 Jun 2007 19:19 GMT

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?

Reply to this Message

ruralguy - 19 Jun 2007 20:42 GMT

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?

>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?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

babysteps - 21 Jun 2007 00:05 GMT

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
[quoted text clipped - 6 lines]
> >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?

Reply to this Message

ruralguy - 21 Jun 2007 05:12 GMT

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
[quoted text clipped - 7 lines]
>> >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?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message