You would need an Access class, not a VB class. You would need to know how to create an event (probably an AfterUpdate event) in addition to the DoCmd.OpenForm command and of course If/Then or Select Case logic. So, you'd need a few different classes to cover all these bases... OR... if you ask me nicely I might make a little Tips & Tricks video to show you how to do it. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
New Visual Basic Courses.