469,072 Members | 1,821 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Display message on Yes/No and blank fields validation

I have table with three fields namely [reportno], [complstatus-yes/no] and [paidbill].. I want that if [reportno] field is blank and I checked [compstatus]=Yes, than message to display "write reportno first before completion".. similarly if I checked [complstatus]=no and written bill no, than message to display "bill cannot be paid before completion".

Pl help me with the above.

Apr 3 '13 #1
4 1111
12,516 Expert Mod 8TB
Use the after update event of those controls to do your validation and messaging.
Apr 3 '13 #2
can it be possible in tables record validation rules.. actually i am new to access and don't know much about VB or macro and how to write the code.. it will be great help if given code or expression... thanks..usman
Apr 5 '13 #3
Similarly i have two fields ie [material](with drop down select list of cs or ss) and [type] (with drop drown list like 1, 2, 3, 4).. so that If I select ss from [material] field than i should select only 2 from [type], otherwise give message that "ss cannot be combined with type 1".. for cs it is ok with 1 or 3 or 4.. kindly help me for solution.. thanks
Apr 5 '13 #4
12,516 Expert Mod 8TB
Unfortunately you will have to use code. You can't use other columns in a validation rule.
Apr 5 '13 #5

Post your reply

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

Similar topics

3 posts views Thread by VMI | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.