Can't get my Dlookup to work!

[Maxelkat]

I'm very inexperienced at Access and am hopelessly out of my depth - please help!

This is my code:

Expr1: DLookUp("[Hours Actual]","Hours - Actual Build Hours","[Cooler Design]=" & [Cooler Design])

I am trying to 'Hours Actual' from the 'Hours - Actual Build Hours' table, where the 'Cooler Design' in that table matches the 'Cooler Design' in the current query.

Instead it's asking me to 'Enter Parameter Value'. If I manually enter one of the possible values of 'Cooler Design', it returns with the corresponding value of 'Hours Actual' as taken from the 'Hours - Actual Build Hours' table, for all records in the current query (instead of comparing the 'Cooler Design' for each record with the corresponding value in the 'Hours - Actual build Hours' table).

Hope this makes sense - if you need any more details, please let me know.

Maxelkat

[khalid]

Hi,
Change the expression as:

DLookUp("[Hours Actual]","[Hours - Actual Build Hours]","[Cooler Design]=" & [Cooler

Design])

Remember!!! there should always be [ ] around the fieldnames, tablesnames in the expression if they have <Spaces> in it.

Hope this help!

[Maxelkat]

Hi Khalid,

Thanks for your help. I changed it, but the criteria part wasn't working either.
My boss managed to get it to work by using relationships between the two instances of 'Cooler Design'. I don't fully understand how it works.
Thanks anyway

Maxelkat

[khalid]

Hi,
What error message you are getting? I am sorry for breaking the code line by mistake, it should be:

DLookUp("[Hours Actual]","[Hours - Actual Build Hours]","[Cooler Design]=" & [CoolerDesign])

What exactly you want to do? can you explain more clearly?