Dlookup in control source

[thescottsman]

Hi all I know I am doing something wrong and it will be staring me in the face

I have a 2 unbound text boxes

1 populates the id number from a table.

I want the other to display the first name where this id occurs.

I amm currently putting this in the control source of the seconded textbox

This is what I have

=dlookup("[FirstName]","[tblUser]","[ID]='[Textbox1]")

can anyone please help?

 

[pr2-eugin]

Why not edit the Form's recordsource? JOIN the two table and get the first name and then you can use this as the control source for the textboxes.