Refresh Data Button

[chris0309 via AccessMonster.com]

Hi All,

Iv got a main form that includes a subform table. Im using the transfer text
method to upload a file into the database, however to view the newly inserted
data you need to close the main form down and open back up. Is there a way
to add a refresh button to the main form to refresh the subform table?

Cheers,

Chris

 

[Douglas J. Steele]

Private Sub cmdRefresh_Click()

Me!NameOfSubformControl.Requery

End Sub

 

[Beetle]

You can requery it with;

Me.NameOfYourSubformControl.Form.Requery

Use the actual name of your subform control (which may - or may not -
be the same as the name of the subform itself).

You could do this in the click event of a command button
or just as an additional line in the procedure that handles
the transfer text (no command button needed).

_________

Sean Bailey