Refresh subform

[Guest]

Hi,

I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
button on the main form and it deletes every record in a table
(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
information (I can pause the code and see the updated records) but the
subform shows '#DELETED' for each field in each record.

I can close the main form and reopen it however I want to do more work in
the code but want the sub form to display the correct output.

I've tried Requery, Me.Requery etc but to no avail.

Thanks in advance.

 

[Marshall Barton]

I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
button on the main form and it deletes every record in a table
(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
information (I can pause the code and see the updated records) but the
subform shows '#DELETED' for each field in each record.

I can close the main form and reopen it however I want to do more work in
the code but want the sub form to display the correct output.

I've tried Requery, Me.Requery etc but to no avail.

The syntax to requery a subform from code in the main form
is:

Me.subformcontrolname.Form.Requery

 

[Guest]

Hi Martin,

That (as you probably know) worked!!! Thanks for your help.