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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't get out of a subform in datasheet view and back to main form

Status
Not open for further replies.

TomDuCrosbie

Technical User
Aug 28, 2003
27
US
i'm stuck in my subform. I have a subform in datasheet view. When I enter data in the next line, I can't get out of the sub form and back to the main form unless I press ESC. The subfrom has an after update event that I know is the problem, as it didn't do this before i added it. This is the evnet.
Private Sub Form_AfterUpdate()
Me.txtUpdatePerson.Value = NetUserID
End Sub

NetUserID is a function that pulls the users network ID.

Any ideas what could be keeping me in the subform?
Tom
 
You need to issue your command in the BeforeUpdate event rather than the AfterUpdate event.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top