Re: Require field entry based on data entered in another field.
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 19:42:31 +0900
Create a Validation Rule on your table.
For details, see the 2nd example in the 2nd section of this article:
http://allenbrowne.com/ValidationRule.html#TableValidationRule
Be sure to bracket carefully if you are combining ANDs and ORs on multiple pairs of fields.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"lsimonelli via AccessMonster.com" <u40941@uwe> wrote in message
news:7ef46b00eff6a@xxxxxx
On a form, how do I require entry of a field based on the data in another
field? I do not want to require at the table level.
I have a field that the user selects where a refund goes. If they choose
"Other", field "Other Explanation" cannot be Null. If they choose
"Producer" then field "Producer Code" cannot be Null.
Your help would be greatly appreciated!!
.
- Follow-Ups:
- Re: Require field entry based on data entered in another field.
- From: lsimonelli via AccessMonster.com
- Re: Require field entry based on data entered in another field.
- References:
- Require field entry based on data entered in another field.
- From: lsimonelli via AccessMonster.com
- Require field entry based on data entered in another field.
- Prev by Date: Re: How convince Access to stop "fixing" my text?
- Next by Date: Query distinct and concat
- Previous by thread: Re: Require field entry based on data entered in another field.
- Next by thread: Re: Require field entry based on data entered in another field.
- Index(es):
Relevant Pages
|
