Form and Subform synchronising Q for Anthony | Access forum

Hi Anthony.
Have another one for you. I have a form of a table. The fields are shown on the form and below is a scrollable view of the table. Using the record navigation keys allows you to scroll through the table and the selected record is shown in the main form. The same can be achieved by clicking on a record in the scrollable view at the bottom.

Where I come undone is that I have a check box, this is a field in the main table. The idea is that when this check box is true then an append query will run, search for the checked record and append it to another table. The check box is made visible=false and a control button is used to make the check box=true. And after to open a form to allow editing of the appended-to table.

I have used the following code:
Private Sub Command50_Click()
CheckBoxName = True
If CheckBoxName = True Then
DoCmd.OpenQuery "QryName", acViewNormal, acEdit
DoCmd.Close acQuery, "QryName"
End If
DoCmd.OpenForm "FrmName", acNormal
End Sub

I have been using multiple combo boxes to select records in the main form, and they have been working. Using code again:
Combo33 = FieldName
Combo34 = FieldName etc.

Whenever I hit the control button to append to the table the query will run, the form will open but the wrong record is shown in the table.

It seems to me that just because a record is viewed on the main form, it is still possible the form still thinks that another record is actively/currently selected.

Any thoughts on solving this one?