Record update in a form and automatically reflect in the datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write codes that when I click a record in a datasheet in a
subform, a form will pop up with the corresponding record. After I update
the record, click the save button and the form will be closed and the changes
will automatically reflect in the datasheet. I will appreciate anyone who
will give me a hand on how to write code to trigger the pop up with the
corresponding record.

Best regards,

SC
 
sc said:
I am trying to write codes that when I click a record in a datasheet in a
subform, a form will pop up with the corresponding record. After I update
the record, click the save button and the form will be closed and the changes
will automatically reflect in the datasheet. I will appreciate anyone who
will give me a hand on how to write code to trigger the pop up with the
corresponding record.
Click to expand...


Check your earlier post with the same question.
 
The edit should be reflected automatically. If you're dealing with a
subform and the data doesn't update (which it should), simply requery
the subform. [Forms]![myMainForm].form![mySubform].requery

That should do it.
 
Back
Top