combo box question

[jcripe]

Question: I have a combo box on a form filled with all fields from one table, with exception of 6 combo boxes that get selection data from second table. I want to save the selection to a field in a third table. How do I do this?

 

[Ken Snell]

Save the selection in the combo box ? Is that what you mean?

In order to do this, the best option is to include the third table in the
form's recordsource query, and then bind the combo box to the field in that
table.

If including the third table results in a nonupdatable query, then you'll
need to use VBA code to write the data into the third table. This usually is
done either by running an update query (or an append query, depending upon
what you're doing) within code, or by opening a recordset based on the third
table and editing a record or appending a record.
--
Ken Snell
<MS ACCESS MVP>

Question: I have a combo box on a form filled with all fields from one

table, with exception of 6 combo boxes that get selection data from second
table. I want to save the selection to a field in a third table. How do I
do this?

 

[Jenny]

Ken
I made my combo box from a lookup table. When I make a selection i want to save that information for the students records.
Thanks