Is there a way to only allow a button linked to a subform/table to be 'clickable' if a specific item is selected in a combo box. I have a member status list. I only want a "death info" button connected to a subform/table to be opened if that member status combo box "deceased" is selected. So if someone is still alive, that "death info" button is NOT clickable/selectable. Thanks in advance.
Sami Shamma
@Reply 2 years ago
Yes
In the 'on click' event, test for your condition and if not deceased then exit sub else open the form.
Sami Shamma
@Reply 2 years ago
If you are testing the value in a combo box, remember the syntax
Statuscombo.column (x) where x is the column number in the combo box. First column is 0
Will WHOP
@Reply 2 years ago
Thanks, I'll try that.
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
Visitor Forum.
