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

Code on sub-form not working

Status
Not open for further replies.

mobile2

Programmer
Dec 19, 2002
38
0
0
GB
I am using Access 97 and trying to get a checkbox named "RegistersUpdateUser" to update on a mainform when a selection "Registers Updates" is made from a combo box named "ContactType" on a sub form. This is the VBA code I am using on the subform but nothing is happening:

Private Sub Form_AfterUpdate()

If Me.ContactType = "Registers Updates" Then
Me.Parent![RegistersUpdateUser] = "Yes"
End If

End Sub

I would appreciate your advice. Thanks
 
Hi,

If you put the code in the AfterUpdate of the ContactType field instead of the Form it should work.

Hope it helps.
 
I just needed a little bit help and you were there. Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top