ListBox question. Searched the forums, no luck.

[arman_canada]

Hi, I have a field in a table with over 600 data values. I also have a database (Form) with over 200 records, each switching to the next record when I use the scroll ball on my mouse.
My problem is, I made a listbox on my database form, connecting it to the over 600 data values. The purpose of it is for me to pick unique values from the 600 + table for each record. BUT what happens instead is when I pick the values for the first record, and then I go to the next record, the same data values from the first record are still there for the all the following records.

Does anyone have any suggestions?

Thank you.

(I apologise if a question like this already exists on AWF.)

 

[boblarson]

Sounds like your control is not bound to a field. Also, you can't use a multi-select listbox for a single record in a bound form. When you move to multi-select you then have a one-to-many relationship which means that the values for that list box should be stored in another table so that you can have multiples. It usually is displayed and used in a subform but a list box can be used but it takes coding to make it work (and you still need that other table).

 

[arman_canada]

Thank you for your help, but I'm more lost than a fork in a cupboard full of knives. Where are the "scales" where I can click to give u a higher rep?

Thank you.

 

[boblarson]

Thank you for your help, but I'm more lost than a fork in a cupboard full of knives. Where are the "scales" where I can click to give u a higher rep?

Thank you.

Don't worry about the rep at the moment because you don't have enough time on the board or post count to actually add anything. But, also, if you can post your current db (first go to Tools > Database Utilities > Compact and Repair and the zip the file with WinZip or something like it). It has to be 393Kb or less to post and you should make a copy and change any sensitive data.