combo box selected value not displayed

[Guest]

I have a form in which the first field in the tab order is a combo box. The
drop down displays properly, and the selected item is stored properly in the
record, but once the selection is made, the value will not display in the
field. The control source of the combo box is the field vendor_number. The
row source is a query:

SELECT Vendor.[VEND_NO], Vendor.VENDOR, Vendor.[1ADDR]
FROM Vendor
ORDER BY vendor;

vendor is a linked text file. The field is bound to column 1, the column
count is 3, and the column widths are 0";1.5";1"

This used to work fine. I have been enhancing the form with additional
error checking and some new fields, but have made no changes to the combo box
or the underlying table/query. Can anyone suggest what might be causing
this?

 

[Guest]

Hi Sandy

Not really sure if it's like this on your form or you may have just put it
like this so we can see it easier. But if it IS like your post on your form
- change it to this

SELECT Vendor.VEND_NO, Vendor.VENDOR, Vendor.1ADDR FROM Vendor ORDER BY
[VENDOR];

Also your column widths should be like this 0;1.5;1 (not 0";1.5";1")
Although again i may be that you have just put them here with " for ease of
viewing.

 

[Guest]

Thanks for replying. The inch indicators on the column widths are added by
Access - I didn't put them in. I tried your suggestion for the query, but
it did not change the situation any. I am using Access 2002. Any other
suggestions?

Hi Sandy

Not really sure if it's like this on your form or you may have just put it
like this so we can see it easier. But if it IS like your post on your form
- change it to this

SELECT Vendor.VEND_NO, Vendor.VENDOR, Vendor.1ADDR FROM Vendor ORDER BY
[VENDOR];

Also your column widths should be like this 0;1.5;1 (not 0";1.5";1")
Although again i may be that you have just put them here with " for ease of
viewing.



--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.

I have a form in which the first field in the tab order is a combo box. The
drop down displays properly, and the selected item is stored properly in the
record, but once the selection is made, the value will not display in the
field. The control source of the combo box is the field vendor_number. The
row source is a query:

SELECT Vendor.[VEND_NO], Vendor.VENDOR, Vendor.[1ADDR]
FROM Vendor
ORDER BY vendor;

vendor is a linked text file. The field is bound to column 1, the column
count is 3, and the column widths are 0";1.5";1"

This used to work fine. I have been enhancing the form with additional
error checking and some new fields, but have made no changes to the combo box
or the underlying table/query. Can anyone suggest what might be causing
this?