combo box selected value not displayed


G

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

Advertisements

G

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.
 
Ad

Advertisements

G

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?

Wayne-I-M said:
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.



SandyR said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top