Part of record cut off in combo box?? 1

[BLutgen]

I am using a combo-box on a form along with a command button to set the criteria for and then to run a query. I set up a combo box to search by distributor. I linked it to the distributor table and to the [distributor] field within that table. Heres my problem.....my company has numerous distributors that operate out of various locations. Therefore, to differentiate them, I included their locations in with their name.
ex. Reagan Industries, Rockford, IL.
However, when I link my combo box to this table, which has about 60 records, it will only list the distributors, combining all the like distributors.
ex. Reagan Industries
I have no idea how to tell location and my combo-box now only has about 9 records in it. Why is it doing this? The field I am using is my primary key and all of the entries are unique. What can I do to change this and get it working? Thanks!

Brad

 

[JoeMiller]

Did you select the Distributor ID when you selected the fields to include in your combo box? If you only selected the name, Access tries to "help" you and combines the like names into 1 record which could be your problem.

Joe Miller
joe.miller@flotech.net

 

[BLutgen]

Thanks for the help, that was it. I just included the ID but hid it and it worked great. Thanks again.

Brad