[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: <bill.singer@at-group.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___