pass dlookup value to a text field.
Posted on 2004-11-07
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")
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