Cascading combobox save information to table and able to go to new record.

[scopes456]

Good day, I have a casading combobox (cmb1 and cmb2) they both work fine . The only issue am having I would like to save what the users select in cmb 1 and cmb2 to a tbl_master. In tbl_master I use Mst_ID to keep track to the records I want to save to the table. I try placing that in my form like I would do with traditional combobox but I have no luck.


Information from cmb1 will save to field "topic"
Information from cmb2 will save to field "reason"


Thank you

 

[JHB]

Can't you just set the Control Source for the comboboxes to the fields?
Else explain how you've set it up.

 

[scopes456]

JHB thank you for your reply. I attached a db where I try to use the control source to link the combo to tbl_master. it will not let me go to add a new record.

 

[bob fitz]

Set the forms Allow Additions to Yes

 

[scopes456]

ALL, thank You , i was able to solve it using a combination of selecting the control source