Link to home
Start Free TrialLog in
Avatar of mc7560
mc7560Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of pique_tech
pique_tech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
' is missing from 'PM'

Me.pm = DLookup("Hours", "qr", "PM = '" & Forms![Form1].[Group] & "'")