form dropdown problem!

[aoken1]

Hi there,

I cant choose more than one value for the whole column using the dropdown control, when I change the value in one row, the other dropdowns are updated to the new value too,
I'm using this dropdown to let users choose foreign key values by choosing the name in the dropdown.

I tried to change the form view to single form and datasheet without any luck

any ideas?

[pbaldy]

It would appear that the combo is unbound, as that will cause the behavior. If it's unbound, how is Access to keep the value by record?

[aoken1]

thanks pbaldy!!

it worked

[pbaldy]

No problem, and welcome to the site by the way!