Add new record or update old using combo box selection

K

KarenB

I have a form that is based on a table (TrainingInfo_tbl). On the form is a
combo box that is retrieving an ID and Name from another table
(Demographics_tbl). The ID is the bound column, and I would like to either
populate the form with the information from the TrainingInfo_tbl if there is
a record that matches, or create a new record in the TrainingInfo_tbl if
there is no match on the ID. Is there a way to do that?
 
Top