DLOOKUP question

[Ben2k]

Have the following

DLOOKUP("budgetunits","tbl_budget","dept='trade' AND month=[forms]![frm_input]![month]")

Is the syntax correct as it just returns #Name?

Thanks

 

[Philem]

Hullo. Try this:

DLOOKUP("budgetunits","tbl_budget","dept='trade' AND month = " & [forms]![frm_input]![month] & ")

HTH
P

 

[Abulafia]

Slight error in the answer above.

=DLookup("budgetunits", "tbl_budget", "dept = 'trade' AND month = " & [forms]![frm_input]![month])

 

[Ben2k]

Thanks guys,

I copied and pasted the second answer but it just says #Error on my form, is there anyway I can find out what the error is?

Ben

 

[Abulafia]

WHat sort of field is Month?

 

[Ben2k]

Text

 

[Abulafia]

=DLookup("budgetunits", "tbl_budget", "dept = 'trade' AND month = """ & [forms]![frm_input]![month] & """")

 

[Ben2k]

Thanks

 

[Abulafia]

As an aside,

Month, in Access, is a reserved word and is not advised as a field name.

Also, I'd question using a month in a field as a Date is always the preferred choice. You can simply get the Month as text from a date with the Format() function.

i.e.

....Format([MyDate, "mmmm") = """ & [Forms]![MyForm]![MyDate] & """")