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

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

P: 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
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,492
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
Expert Mod 15k+
P: 31,492
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

P: 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
Expert Mod 15k+
P: 31,492
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.