list box control field

[ejmiller2]

i have a list box whose ROWsource is from a query. I have the SAME list box whose CONTROLsourse is a field in a table. If I run the query which puts a value in the listbox, the listbox doesnt update the table field. I have the listbox requery even. BUT if i click on the list box, it will place its contents from the list into the table field....HELP

eric

 

[TonyJollans]

Hi eric,

Isn't that the way it's supposed to work? The ROW Source provides the list of possible values for selection and the CONTROL Source takes the SELECTED value. if you don't select a value from the list what do you want to go in the control source?

Enjoy,
Tony