DLookup Error on Query

[kolsen]

I am revisting Access after decades. Once knew my way around but having to relearn



I have a query QryHoursByType that pulls info from two tables
From table Members it gets Member Name, from table Membership Type it gets [Member Type] and [Allocated Hours]

I wish to use a DLookup on a form to retrieve the [Allocated Hours] from the query with the criteria set by a combobox on the form

One selects Member in Combo159 on a form called Tracker which requeries the subform and does some calculations.
The DLookup is in the Allocated Hours text box at the bottom and is supposed to look up the number of allocated hours found in the query.
I have

=DLookUp("[Allocated Hours]","QryHoursByType","[Member Name]=" & [Forms]![Tracker]![Combo159])

But this returns an error. Not sure where I am going wrong.

[pbaldy]

If the field is text you need delimiters:

http://access.mvps.org/access/general/gen0018.htm

[kolsen]

Cant make sense of that and have left office now

[kolsen]

Ahh I see. The criteria is text

[pbaldy]

Have it working now?

[kolsen]

I am in Australia. My work day is about to begin. Will let you know in half hour

[pbaldy]

No worries. I have a daughter in NZ, so I'm familiar with the goofed-up workday down under.

[kolsen]

OK, I have totally confused myself now

How should I change this =DLookUp("[Allocated Hours]","QryHoursByType","[Member Name]=" & [Forms]![Tracker]![Combo159]) ?
what should it be? This does not work
=DLookUp("[Allocated Hours]","QryHoursByType","[Member Name]=" & [Forms]![Tracker]![Combo159] & "")

[kolsen]

Yay!

I got it to work =DLookUp("[Allocated Hours]","QryHoursByType","[Member Name]= '" & [Forms]![Tracker]![Combo159] & "'")

Those pesky apostrophes

[pbaldy]

Glad you got it sorted.