mc7560
asked on
pass dlookup value to a text field.
experts, here's my code for the afterupdate event Combo0 in my form and after update I have a blank field for textbox "PM".
Private Sub Combo0_AfterUpdate()
Me.pm = DLookup("Hours", "qr", "Forms![Form1].[Group]='PM ")
Me.Requery
End Sub
the requery is to run query "qr" whose criteria depends on the value of the above combo box.
Am I doing something similar to a circular formula here? If so, please help
Private Sub Combo0_AfterUpdate()
Me.pm = DLookup("Hours", "qr", "Forms![Form1].[Group]='PM
Me.Requery
End Sub
the requery is to run query "qr" whose criteria depends on the value of the above combo box.
Am I doing something similar to a circular formula here? If so, please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me.pm = DLookup("Hours", "qr", "PM = '" & Forms![Form1].[Group] & "'")