Listbox to provide values and update Table

[Allilue]

Hello,
I have a Form that is populated by a query (qryMasterData). I'd like to insert a Listbox on the form that looks up the values based on a Table (StageLevel). When the user selects the StageLevel, this should then save in the underlying table (tblMasterData).
The Listbox works fine, but I can't seem to get this to save in the underlying table. I have other Textboxes and Yes/No selections on the form that save fine, but don't know what I'm doing wrong with the Listbox?
Thanks!

 

[PHV]

The ListBox could be bound to a field in the underlying table (tblMasterData).
Have a look at the ControlSource property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Allilue]

Thanks.

I can have it bound to the MasterData table, but then how do i get the selection to be the lookup criteria? Does it make a difference if I use a Listbox or a combobox? I've tried the combo and i can get this to link to the masterdata table, but then i lose the ability to allow the user to select from the StageLevel table.

Thanks Again!