Bind List Box result to a Table Field

[David Ball]

Hi Forum,

I have done this before but have not used Access in a long time and can’t work it out (driving me crazy!)

I want a List Box on a Form that takes its available drop-down values from tblDiscipline and puts the value selected into the Discipline Field of tblEquipment.

The problem is I set the Control Source of the List Box to tblDiscipline (so the List Box can use these values for the drop-down selections) and when I make a selection it tries to put it back into tblDiscipline instead of tblEquipment, because I can’t find anywhere to set the table that the result should be Bound to.

How can I set up a control, such as a List Box, so that it gets its values from one table but returns them to another?

Thanks very much

Dave

 

[pbaldy]

The table is determined by the form's record source, which presumably should be tblEquipment. The control source of the listbox would be the appropriate field in that table.