strlinkcriteria mismatch

L

LeParis

I am trying to use several ways to pull a user's record from a form. One is
using an ID and that is working fine.
Where I am having trouble is when users do'nt know their ID, then they can
give y their cityofbirth, dateofbirth,lastname and firstname so I can pull
their record from a form.
To that end, I am trying to use 4 combo boxes to open the form. They are
cbocityOfBirth, cboBirthdate, 2 text fields lastname and firstname to be
manually filled.
Now when I combine the text and date fields to open the form, I am having
a mismatch type error and I can't see why.
I have used all the codes posted here that I could find to no avail.
Here is the code:

Dim stLinkCriteria As String
stDocName = "frm_IDTable"
stLinkCriteria = "([CityOfBirth]=" & "'" & Me![cboCityOfBirth] & _
"' )" And "[BirthDate]=" & "#" & Me![cboBirthdate] & "#"

I want to add here [Lastname]=" & "'" & Me![LastName] and
[Firstname]=" & "'" & Me![firstName]

Thank you so much
 

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

String Criteria To Filter Form 2
Filter Combo Box Listing 5
Change to combo box stops code from returning records 5
How do I get IIf(IsNull.... to work?? 3
alternating cascading combo boxes for filter 3
Access Creating names from fields in access database. 0
Search Form and PickList Form 4
Trying to eliminate duplicate entries 5

Top