469,322 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

we cannot enter a data in a field, when another field does not have data.

2
what validation rule can be used to show :we cannot enter a data in a field, when another field does not have data.for example we can not enter details of a person untill we dont enter his name.
May 13 '10 #1
4 1316
NeoPa
32,173 Expert Mod 16PB
If you don't mind waiting for the record to save, then you can set it in the table's Validation Rule property (Open table for design / View Menu / Properties).
May 13 '10 #2
NeoPa
32,173 Expert Mod 16PB
If it's important that it cannot even be entered then you could handle the state of control A (In the OnCurrent and AfterUpdate event procedures) and set the Enabled property of control B accordingly.

Does this sound like a viable solution for you?
May 13 '10 #3
sirvi
2
@NeoPa
Oh I think i have to wait for saving i chose required option and not allowed zero length, but i want to have an error if before entering name,some body enter the address.
thank you
May 14 '10 #4
NeoPa
32,173 Expert Mod 16PB
Sorry. What did all that mean?
May 14 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Stuart E. Wugalter | last post: by
3 posts views Thread by Bryan Warren via AccessMonster.com | last post: by
5 posts views Thread by lsimonelli via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.