Create a button to call subform

[jimjaix]

Hi, I currently have a subform under one of my froms, I want to hide the subform and create a button. When I click on the button I want the subform to show up and once I am done with the subform auto hide it. Please let me know how to do this I am not good with access.

 

[Chrisopia]

to refer to a subform, this site helpped me:

http://www.mvps.org/access/forms/frm0031.htm

you would use the .visible = true/false option..


e.g.

button_click()

SUBFORM.visible = true

Not sure how you want it to disappear again but you would simply return .visible = false?