DLookUp

[Manuel]

I'm trying to use the function DLookUp so when I enter an
information in a field another field is automatically
entered.
EX: when i enter the job number field in the form, I wasnt
foor job location to be automatically filled. I tried this
but nothing happens:

=DLookUp(" [Job Location] ","[Job Control]"," [Job Number]
= ' " & [Forms]![PO Log Data Entry]![Job Number] & " ' ")

I entered this function in the control source of the text
box, is this the correct way to do it?

help please!

 

[Rick Brandt]

I'm trying to use the function DLookUp so when I enter an
information in a field another field is automatically
entered.
EX: when i enter the job number field in the form, I wasnt
foor job location to be automatically filled. I tried this
but nothing happens:

=DLookUp(" [Job Location] ","[Job Control]"," [Job Number]
= ' " & [Forms]![PO Log Data Entry]![Job Number] & " ' ")

I entered this function in the control source of the text
box, is this the correct way to do it?

If [Job Number] is actually a numeric value (stored in a numeric field) then you need
to lose the single quotes. Otherwise it looks good to me.