DoCmd.openForm Condition Type Mismatch

K

Ken

I am using:
DoCmd.OpenForm "Contacts", , , "LastName = '" & Me!List & "'" And
"CompanyName = '" & Me!List & "'"
on an update for a list box. It worked fine for just the last name, but I
get the first record encountered when there are duplicates. I wanted to add
the CompanyName and I get a type Mismatch but it is the same type as the last
name.

Any help is greatly appreciated.
Ken
 
D

Dirk Goldgar

Ken said:
I am using:
DoCmd.OpenForm "Contacts", , , "LastName = '" & Me!List & "'" And
"CompanyName = '" & Me!List & "'"
on an update for a list box. It worked fine for just the last name,
but I get the first record encountered when there are duplicates. I
wanted to add the CompanyName and I get a type Mismatch but it is the
same type as the last name.

Any help is greatly appreciated.
Ken
Click to expand...

You've got your "And" outside the quotes, where it needs to go inside
them. Try this:

DoCmd.OpenForm "Contacts", , , _
"LastName = '" & Me!List & _
"' And CompanyName = '" & Me!List & "'"
 
K

Ken

thats just embarassing, Thank you much

Dirk Goldgar said:
You've got your "And" outside the quotes, where it needs to go inside
them. Try this:

DoCmd.OpenForm "Contacts", , , _
"LastName = '" & Me!List & _
"' And CompanyName = '" & Me!List & "'"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top