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
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