Rabu, 08 Mei 2019

Re: [MS_AccessPros] Visible Property

 

Hi Bill,
An options group returns a number. Is this bound to a field in the forms record source? What is the name of the option group? What is the name of the subform control?

Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
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)

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar