Record update in a form and automatically reflect in the datasheet

[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

 

[Marshall Barton]

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.

Check your earlier post with the same question.

 

[David C. Holley]

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.