Multiple Validation Rule

[June7]

Again: Can't have VBA behind tables and queries. Build a form to use as a subform. The form will be the SourceObject of the subform container control.



Code goes in the AfterUpdate event of [Local X] textbox on subform.

Why using LIKE operator? LIKE is only useful with wildcards. Just use =.

[gatsby]

okay will try to test this one. thank you so much.

yes i agree with VBA behind tables and queries but how about multiple validation rules there (not VBA or coding) just plain validation rules using expressions?

[June7]

Think I finally get your question. Maybe. I am now testing an IIf expression in ValidationRule. Seems to be working. So might be able to do:

IIf(lkpAssembly="Deck", Nz(Me.[Local X], 0) < 5 Or Nz(Me.[Local X], 30) > 25, IIf(lkpAssembly="DSF",...)))))

[gatsby]

yup. i tried that iif also since i did a lot of research on this prob but i cant get it right and the last resort is to have a vba coding and im not good at it, so im here.

anyway, will try your suggestion tomorrow. will let you know if i got it right, i hope so at least. thanks for your time June7, i really do appreciate it.

[June7]

I first tested this expression:
IIf(1=1, "02", "03")

That worked.

I tried:
IIf(1=1,>"10" And <"15",>="01" And <"10")

That didn't work.

Then I tested with a field:
IIf([Division]="LLBB", >"10" AND <"15",>="01" AND <"10")

That didn't work either.

So I am thinking the answer is No. Hence the VBA code to validate entry.

[gatsby]

yah no choice but VBA. been researching that for days also. i still have lots of questions about MS Acess, because this software or application is quite good for database. and this forum is nice also for people who wants to know more about MS Access.