DLOOKUP question

[hunterfan48]

Hey guys,
I'm using the DLookup function to pull in values from another table into a form.

Here's the formula.

=DLookUp("[State]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID])

=DLookUp("[SCF_ID]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID])

The problem is that this is the same formula for two different fields, but one pulls the value in while the 2nd one doesn't (SCF_ID).

 

[hunterfan48]

bump bump bump

 

[RailwayKen]

Doubt this is it, but here's all I can think of...
Is the field actually named "SCF_ID"?
Or is it "SCF ID" (no underscore)?

 

[hunterfan48]

SCF ID

that's exactly how it is

 

[JANR]

Then remove the underscore from your second Dlookup

=DLookUp("[SCF ID]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID])

JR

 

[hunterfan48]

ok...let me give that a try.

Easy to see now...thanks for correcting my mistake!