DLookup

  • Thread starter Thread starter Jeffmklein
  • Start date Start date
J

Jeffmklein

I am trying to create a check in my form that looks for any duplicate client
names. I am using the below code to return the ClientID value if a record
is found.

DLookup("[ClientID]", "[Clients]", "[ClientLastName] =
Form.[ClientLastName]")

This works OK but I have seperate fields for the ClientFirstName and
ClientLastName
So I try:
DLookup("[ClientID]", "[Clients]", "[ClientLastName]&[ClientFirstName] =
Form.[ClientLastName]&[ClientFirstName]")
This is not working. I think DLookup does not like combining the lookup
fields.

Any suggestions on a solution???
 
DLookup("[ClientID]", "Clients", "[ClientLastName] = '" & [ClientLastName] &
"' And [ClientFirstName] = '" & [ClientFirstName] & "'")

the syntax may change slightly depending on exactly where you're using this
expression (macro condition, VBA code, etc.).

hth
 
Tina,
Thanks for the reply. This seems to work great. Thank you very much
Jeff

tina said:
DLookup("[ClientID]", "Clients", "[ClientLastName] = '" & [ClientLastName] &
"' And [ClientFirstName] = '" & [ClientFirstName] & "'")

the syntax may change slightly depending on exactly where you're using this
expression (macro condition, VBA code, etc.).

hth


Jeffmklein said:
I am trying to create a check in my form that looks for any duplicate client
names. I am using the below code to return the ClientID value if a record
is found.

DLookup("[ClientID]", "[Clients]", "[ClientLastName] =
Form.[ClientLastName]")

This works OK but I have seperate fields for the ClientFirstName and
ClientLastName
So I try:
DLookup("[ClientID]", "[Clients]", "[ClientLastName]&[ClientFirstName] =
Form.[ClientLastName]&[ClientFirstName]")
This is not working. I think DLookup does not like combining the lookup
fields.

Any suggestions on a solution???
Click to expand...
Click to expand...
 
you're welcome :)


JeffMKlein said:
Tina,
Thanks for the reply. This seems to work great. Thank you very much
Jeff

tina said:
DLookup("[ClientID]", "Clients", "[ClientLastName] = '" &
Click to expand...
[ClientLastName]
&
"' And [ClientFirstName] = '" & [ClientFirstName] & "'")

the syntax may change slightly depending on exactly where you're using this
expression (macro condition, VBA code, etc.).

hth


Jeffmklein said:
I am trying to create a check in my form that looks for any duplicate client
names. I am using the below code to return the ClientID value if a record
is found.

DLookup("[ClientID]", "[Clients]", "[ClientLastName] =
Form.[ClientLastName]")

This works OK but I have seperate fields for the ClientFirstName and
ClientLastName
So I try:
DLookup("[ClientID]", "[Clients]", "[ClientLastName]&[ClientFirstName] =
Form.[ClientLastName]&[ClientFirstName]")
This is not working. I think DLookup does not like combining the lookup
fields.

Any suggestions on a solution???
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First initial of name 1
Showing the most recent record for each client 8
Referencing a calculated column of a query/combobox 2
Auto expand not working with comma 2
Item not on the list.............yes it is! 3
Displaying data from two different tables on one Form. 1
Editing records from two different tables on a single form 1
Check for duplicates 2

Back
Top