combo box question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>

jcripe said:
Question: I have a combo box on a form filled with all fields from one
Click to expand...
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
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
 
Back
Top