Hi,
I am using the following code to add comments from a subform to a table. The subform is populated by a combo box:
Private Sub Command9_Click()
DoCmd.GoToRecord acDataForm, "frmMain", acNewRec
DoCmd.OpenQuery "qry - Archived"
DoCmd.OpenQuery "delete_qry_Final_Details"
DoCmd.OpenQuery "qry_Final_Details"
Me.frmsubform.Requery
Me.Combobox.Requery
Me.Combobox.Value = Null
End Sub
the problem is when I save the comments. and click on the next value of combo box, the subform doesn't populate. But if i close the form, open again - then it works.
what am I missing here? Thanks!
frmMain is the main form.
qry - Archived is used to archive the comments
delete_qry_Final_Details deletes the table the subform is based on
qry_Final_Details appends the table again
delete/append is used to ensure that already commented trailers do not appear in the combo box.
any other idea to approach this issue?
Thanks!
I am using the following code to add comments from a subform to a table. The subform is populated by a combo box:
Private Sub Command9_Click()
DoCmd.GoToRecord acDataForm, "frmMain", acNewRec
DoCmd.OpenQuery "qry - Archived"
DoCmd.OpenQuery "delete_qry_Final_Details"
DoCmd.OpenQuery "qry_Final_Details"
Me.frmsubform.Requery
Me.Combobox.Requery
Me.Combobox.Value = Null
End Sub
the problem is when I save the comments. and click on the next value of combo box, the subform doesn't populate. But if i close the form, open again - then it works.
what am I missing here? Thanks!
frmMain is the main form.
qry - Archived is used to archive the comments
delete_qry_Final_Details deletes the table the subform is based on
qry_Final_Details appends the table again
delete/append is used to ensure that already commented trailers do not appear in the combo box.
any other idea to approach this issue?
Thanks!