Simple DLookup Question

[Deggsy]

Maybe I'm having a brainfreeze (Maybe? LOL), but can anyone explain to me what this DLookup will do:

=DLookUp("[Location Name]","Del_PostCode","[Employee Number] =" & [Forms]![Course Booking]![Employee Number])

In the course booking form where it sits, it should bring up the store location connected with the employee number, and it works for most of the employee numbers entered, but some of the records aren't showing the location details, and I'm trying to determine if the fault lies with the form or with the records (I'm assuming the records, as like I said it does work for many examples, just a few)

[pbaldy]

I would agree that it's something with the records, given that it works for many. See if there is a record to find for an employee number that fails. Can you post the db here?

[Micron]

If you still need an answer as to what the lookup is doing, howboutdis:
look in field [Location Name] in table [Del_Postcode] and retrieve the value in [Location Name] where the [Employee Number] equals the value in the Employee Number control on the Course Booking form.

[John_G]

My guess would be that the table Del_Postcode is missing entries for some employees, so you won't get a location for employee number that are on your form, but have no matching record in Del_Postcode. The DLookup returns a Null, but assigning a Null to a form field causes no problems.

Try this:

=Nz(DLookUp("[Location Name]","Del_PostCode","[Employee Number] =" & [Forms]![Course Booking]![Employee Number]),"No location found")

[Deggsy]

My guess would be that the table Del_Postcode is missing entries for some employees, so you won't get a location for employee number that are on your form, but have no matching record in Del_Postcode. The DLookup returns a Null, but assigning a Null to a form field causes no problems.

Try this:

=Nz(DLookUp("[Location Name]","Del_PostCode","[Employee Number] =" & [Forms]![Course Booking]![Employee Number]),"No location found")

Thanks - I suspected it was due to missing entries for new employees, so I'll give this a try :-)