By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,576 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Multiple Validation Rules in Form Field

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.