combo box problem

[Guest]

i have a combo box based on a query. The query references a table with about
6000 records. If the user selects any of the first 1200 or so, it works
properly - the value of the key to the table is stored in the record and the
name is displayed on the form. If the user selects an item later in the
table, however, the value of the key is stored in the table, but nothing
displays on the form. How can I fix this?

The row source for the combo box is: SELECT Vendor.[#VEND], Vendor.VENDOR,
Vendor.[1ADDR], Vendor.[2ADDR], Vendor.[3ADDR], Vendor.[4ADDR] FROM Vendor;

The bound column is 1, the column count is 5, the column widths is 0",1'

 

[Keith Wilby]

i have a combo box based on a query. The query references a table with
about
6000 records. If the user selects any of the first 1200 or so, it works
properly - the value of the key to the table is stored in the record and
the
name is displayed on the form. If the user selects an item later in the
table, however, the value of the key is stored in the table, but nothing
displays on the form. How can I fix this?

The row source for the combo box is: SELECT Vendor.[#VEND],
Vendor.VENDOR,
Vendor.[1ADDR], Vendor.[2ADDR], Vendor.[3ADDR], Vendor.[4ADDR] FROM
Vendor;

The bound column is 1, the column count is 5, the column widths is 0",1'

Why is the column count 5 when the widths indicate 2 columns and the SQL is
selecting 6 fields? Also, the column width separator should be a
semi-colon.

Regards,
Keith.
www.keithwilby.com

 

[Guest]

OK - I made all of those things consistent and correct, but I still have the
same problem - Once I select the vendor, it only displays the name if it is
one of the first 1262 records.

i have a combo box based on a query. The query references a table with
about
6000 records. If the user selects any of the first 1200 or so, it works
properly - the value of the key to the table is stored in the record and
the
name is displayed on the form. If the user selects an item later in the
table, however, the value of the key is stored in the table, but nothing
displays on the form. How can I fix this?

The row source for the combo box is: SELECT Vendor.[#VEND],
Vendor.VENDOR,
Vendor.[1ADDR], Vendor.[2ADDR], Vendor.[3ADDR], Vendor.[4ADDR] FROM
Vendor;

The bound column is 1, the column count is 5, the column widths is 0",1'

Why is the column count 5 when the widths indicate 2 columns and the SQL is
selecting 6 fields? Also, the column width separator should be a
semi-colon.

Regards,
Keith.
www.keithwilby.com