Sent: Wednesday, May 8, 2019 4:54:23 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Visible Property
I have Access 365 and am starting a new project so I think you will be hearing more of me.
I am creating a health insurance enrollment database..
Here is the first issue.
If a person is single, with no dependents the form is shorter.
If the person has dependents I will need them to fill in the depends information on a Sub Form. I do not want the sub form to be visible unless the new employee indicates they have dependent. I am asking the question on the form and the employee is to respond using an Options box with the "Yes" or "No" as their choices. If they check no to the question then they just continue on. If they check Yes, I want the Sub Form to appear.. What is the best way to change the "Visible" Property of the sub form after the options box input.
A macro?
Code? A quick sample is always best for me.
Thanks,
Bill
Bill Singer
Minnesota
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar