Re: [MS_AccessPros] Lookup code

 

Hi John,

Sorry - yes I meant DLookup.

I entered the code you suggested and got the following message on the highlighted code below

    "You entered an invalid argument in a domain aggregate function"

This is the code:

    If Not IsNull(DLookup("DOB", "Members", "[Members].[DOB] = # " & Me!DOB & " #")) Then
     mes = MsgBox("possible duplicate date", vbOKOnly)

I am still going wrong somewhere.

I would also like if the DOB already exist in the table to show in the mes the first and last names of the member with the duplicated DOB.  Possible?

Oh!  I forgot to mention Access 2010 .mde database with linked member table if that makes a difference.

 

Thanks

Toukey

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___