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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Optionbutton Not working 3
Link a text box based on drop down box with four options MS Word 365 0
Generated text copies into another template 0
Copy previous record into form field 0
Combo Box matching to entire record 5

Top