Help NEWBIE here with DLookUp

[mloucel]

I am a bit new with VBA and I cannot find a way to get this right.

On a form I have 3 records that I Input

FirstName LastName and DateOfBirth

I need to create a dlookup to search for the 3 of them from a table

Yes I am lost, specially on the Date.

FN and LN and DOB are sourced directly to the Table.



I am creating a NEW record and I am trying to dlookup those 3 values if they exist in my table.

Thanks for your help.

Maurice.

[pbaldy]

See if this helps, noting the multi-criteria example at the end:

http://www.theaccessweb.com/general/gen0018.htm

Welcome to the site by the way, from west of you in Nevada.

[Welshgasman]

Put the criteria into a string variable.
Debug.print it until you get it correct
Then use that in the function.

Date will need to be in mm/dd/yyyy format, but as you are in the USA, that should not be a problem for you.
You can use yyyy-mm-dd also, but it is your country format, so need really, unless you prefer that format?

[xps35]

Show us what you tried.

If you need this to check if a record with that data already exists, you might also consider creating a unique index on the three fields together. Then it is impossible to create duplicate records and you do not have to use VBA.

[June7]

Unique index on name fields would prevent multiple people who have same name. Sure, it would be rare in same dataset but not impossible. Names are poor unique identifiers.