New to access and I thought this would be simple to do, but I am finding a hard time searching the internet for some clues on how to do it. Any help would be appreciated, thanks.

Combobox1 filters the selections in combobox2. This works already.

I need for combobox2 selection to update table1 tb_checkbox1 to 'yes'.
This will remove it from the combobox2 list, that function works.

I also need the mf_text1 to be placed into tb_text1 of the record selected in combobox2.

When the mainform/subform record is deleted, I need the tb_text1 and tb_checkbox to be removed making that record available again.

Table1
tb_Text1
tb_CheckBox1 (yes/no)

MainForm
mf_Text1

SubForm
ComboBox1
ComboBox2