Multiple Validation Rules in Form Field

[ilushn]

I am in the process of creating a database for an upcoming conference.
I have created a seperate database for the conference. We are a
headquarter office and most (not all) of our attendees will be from
the regional offices. I have created a form (Attendees) and a sub-form
(tblClinic Subform). The information is pulling from 3 tables:
Attendee Information, tblClinic, tblClinicLocations & tblClinicPeople.

My problem is that I want the form to automatically pull in the
center's mailing address for attendees coming from a center into a
section on the form that I called "Clinic Information". I can almost
get it to do this using the string: =[LastName] Like [tblClinic
subform].[Form]![txtlname] - my problem is that if either two people
have the same last name or if someone who is not from a center has the
same last name as a person from a center my form pulls in the wrong
infromation or irrelevant information. Is there some way to do
multiple validations, like first and last name?

Thanks!
Msilushn

[Bob Quintal]

ms******@yahoo.com (ilushn) wrote in
news:99*************************@posting.google.co m:

I am in the process of creating a database for an upcoming
conference. I have created a seperate database for the
conference. We are a headquarter office and most (not all) of
our attendees will be from the regional offices. I have
created a form (Attendees) and a sub-form (tblClinic Subform).
The information is pulling from 3 tables: Attendee
Information, tblClinic, tblClinicLocations & tblClinicPeople.

My problem is that I want the form to automatically pull in
the center's mailing address for attendees coming from a
center into a section on the form that I called "Clinic
Information". I can almost get it to do this using the string:
=[LastName] Like [tblClinic subform].[Form]![txtlname] - my
problem is that if either two people have the same last name
or if someone who is not from a center has the same last name
as a person from a center my form pulls in the wrong
infromation or irrelevant information. Is there some way to do
multiple validations, like first and last name?

Thanks!
Msilushn

Yes: =[LastName] Like [tblClinic subform].[Form]![txtlname] AND
[first Name] like [tblClinic subform].[Form]![txtfname]

Bob Quintal

[ilushn]

Bob,

Thanks for the input. For some reason it didn't work, I think I was
putting the information into the wrong area. I put it into the query
and now it seems to be running okay. Thanks for getting me back on
track!

Msilushn