[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

Access form events

There are too many!

I have a Yes/No field in my table that is set using a radio button on the form.  If the user clicks on the button I have another field that is made visible that they must enter something.

Which button event should I use to make the field visible, Before update, After update or Click?

When they type into the visible field which event should I use to run code that validates the field?
0
IBMJunkman
Asked:
IBMJunkman
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Which button event should I use to make the field visible, Before update, After update or Click?"
AfterUpdate or Click

"When they type into the visible field which event should I use to run code that validates the field? "
BeforeUpdate

mx
0
 
hnasrCommented:
Yes/No:   After Update
Field: Before Update or On Change if you want to check while typing
         For the field you may use database rules, Validation Rule and Validation Text
0
 
IBMJunkmanAuthor Commented:
Did what I needed.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now