Can I have a field in a database that has a validation rule iif>2 go to a re-order form
Can I have a field in a database that has a validation rule iif>2 go to a re-order form
Hello Rainman. Yes you can, but it's gonna take a bit of VBA programming. The idea is:
a. Create the AfterUpdate event of the textbox.
b. Create an IF statement inside the event.
c. Create a DoCmd command inside the IF statement.
Hope this helps.
Good luck.