redraw a subform on another form

  • Thread starter Thread starter Peter Morris
  • Start date Start date
P

Peter Morris

A similar question to one I asked a few days ago. This
is slightly different

Here's the situation.

I have a form MAIN_FORM which displays a continuous subform FRM_MY_SUB.
The subform displays data from a query on table MY_TABLE.

If I click on a button I display another form FRM_NEW_ENTRY. On this
form I can enter data. When I click the "save" button on my form I
want to run code that does the following:

1) Writes the new data to MY_TABLE
2) redraws/ refreshes FRM_MY_SUB so it shows the new row
3) closes FRM_NEW_ENTRY

No 1 & 3 I can do, but what is the syntax for redrawing the subform?

TIA
 
Peter said:
A similar question to one I asked a few days ago. This
is slightly different

Here's the situation.

I have a form MAIN_FORM which displays a continuous subform FRM_MY_SUB.
The subform displays data from a query on table MY_TABLE.

If I click on a button I display another form FRM_NEW_ENTRY. On this
form I can enter data. When I click the "save" button on my form I
want to run code that does the following:

1) Writes the new data to MY_TABLE
2) redraws/ refreshes FRM_MY_SUB so it shows the new row
3) closes FRM_NEW_ENTRY

No 1 & 3 I can do, but what is the syntax for redrawing the subform?
Click to expand...


Me.subformcontrolname.Form.Requery
 
Back
Top