Dlookup

[Guest]

I have found many discussions on this topic, but I am still having problems
with my expression.

Here is what I am trying to do:

I want to type in a cost code....then for the description of that cost code
to automatically fill in. There is already a table that has these codes and
descriptions (cost 3).

In the form I created, in the descriptions box:

=dlookup("[description]","cost code", "[cost code]="& table![cost3]!cost code)

I fill like I am looking at this expression wrong...any help would be
appreciated.

TIA

LM

 

[Guest]

The DlookUp should be

=DlookUp("FieldName","TableName",Criteria)

Try something like
=dlookup("[description]","cost3", "[cost code]= " & [cost code])

**** Note ****
"[cost code field name in the table ]= " & [cost code in the form])

If the cost type is text then try
=dlookup("[description]","cost3", "[cost code]= '" & [cost code] & "'")

 

[Guest]

Thank you!

The DlookUp should be

=DlookUp("FieldName","TableName",Criteria)

Try something like
=dlookup("[description]","cost3", "[cost code]= " & [cost code])

**** Note ****
"[cost code field name in the table ]= " & [cost code in the form])

If the cost type is text then try
=dlookup("[description]","cost3", "[cost code]= '" & [cost code] & "'")


--
Good Luck
BS"D

I have found many discussions on this topic, but I am still having problems
with my expression.

Here is what I am trying to do:

I want to type in a cost code....then for the description of that cost code
to automatically fill in. There is already a table that has these codes and
descriptions (cost 3).

In the form I created, in the descriptions box:

=dlookup("[description]","cost code", "[cost code]="& table![cost3]!cost code)

I fill like I am looking at this expression wrong...any help would be
appreciated.

TIA

LM