Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Record immediately in forms

Status
Not open for further replies.

soldieryap

Programmer
Aug 15, 2000
59
MY
when i'm key in the record, how can i update directly so that the current record will be updated in the form? if i want to update the record of the subform in the mainform, how can i update directly, so it will show the latest information? i need to use VBA, requery? ?? thanks
 
The form Refresh method will reload the form's controls from the underlying record source. Note that if the current record has been deleted, the controls will all show "#Deleted".

To refresh a subform from code in the mainform:
Me!<subformcontrol>.Form.Refresh
Rick Sprague
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top