Run-time Error 3075

[Guest]

I am receiving the following error when attempted to do a last name and first
name search. The problem seems to lay with the first name (as I can do a
last name search).

Run-time error '3075'

Extra ) in query expression '(((tblMaster.LastName) Like 'berry*') And
(tblMaster.FirstName) Like 'c*))'.

Here is the VB Coding:


Forms![frmBioA1VIP].RecordSource = v4
Forms![frmBioA1VIP].Refresh
Forms![frmBioA1VIP].SetFocus
DoCmd.Close acForm, "frmViewVIPBio"


Any ideas how to solve this issue?

 

[Douglas J Steele]

Did you count the parentheses? I count 4 opening, and 5 closing. You're also
seem to be missing a closing quote after 'c*.

Personally, I'd use:

((tblMaster.LastName Like 'berry*') And (tblMaster.FirstName Like 'c*'))

 

[Guest]

Thanks. The extra ) was definitely the problem. Sorry for the delay in
response.

Did you count the parentheses? I count 4 opening, and 5 closing. You're also
seem to be missing a closing quote after 'c*.

Personally, I'd use:

((tblMaster.LastName Like 'berry*') And (tblMaster.FirstName Like 'c*'))


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am receiving the following error when attempted to do a last name and first
name search. The problem seems to lay with the first name (as I can do a
last name search).

Run-time error '3075'

Extra ) in query expression '(((tblMaster.LastName) Like 'berry*') And
(tblMaster.FirstName) Like 'c*))'.

Here is the VB Coding:


Forms![frmBioA1VIP].RecordSource = v4
Forms![frmBioA1VIP].Refresh
Forms![frmBioA1VIP].SetFocus
DoCmd.Close acForm, "frmViewVIPBio"


Any ideas how to solve this issue?