Refresh subform

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

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.
 
Andrew said:
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.
Click to expand...


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

Me.subformcontrolname.Form.Requery
 
Back
Top