Selective Data Entry in access 2010 Forms

[Fabricio Sanches]

Hello Guys , I am facing an issue with an access 2010 form, I wanna add a selective field in the form: for example I wanna add a field named "Contacted ?" the answer is a Boolean field "Yes" or "No", in this case if the answer is "Yes" so the form should open up a couple of fields such as "When the contact was Made ?" and "Who was Contacted ?", etc. Also if the answer for the field was "No" so no fields should appear in the form. I already added those fields in the corresponding Data Table which the form will pull up the data.

Any suggestions how can I implement this in an access 2010 form ?

I really appreciate your answers, thanks !!

[pbaldy]

This type of thing?

http://www.baldyweb.com/ConditionalVisibility.htm

[Fabricio Sanches]

Ok , Yes it is. I have a doubt related with this example.
In this case I have the field "Contacted ?" and the answers "Yes" or "No" , where should I insert this expression in the form ?
In the form properties , in the table properties or the field properties ?

Thank you for helping me out.

[pbaldy]

As noted in the link:

You would put that code in the After Update event of the control you're testing, so that when you changed the value it would execute the code. You might also want the code in the Current event, which would fire when you change records

If you're unsure where VBA code goes:

http://www.baldyweb.com/FirstVBA.htm