Hi
I'm attempting to base the field that I look up on the record I click on, in a continuous form so if I have
'Another Field' Would be a combo box and 'Field' would vary depending on the record I selected on the continuous formCode:Dlookup("Field","Table","PK =" & Me.Another Field)
I would be most grateful for a prod in the right direction
Thanks