Subforms

[paultri]

I have a form that has a field to enter a sku# for a product a customer has returned, i failed to account for if a customer returns more than one product. I didnt want to create 10 different fields to enter sku #'s so i created a subform with the additional sku# fields, my questions is, I cannot figure out how to hide a subform so that it only shows when a button is pushed...is this even a possibility? any help is appreciated

Thanks,
Paultri

 

[llkhoutx]

You have hide the subform on some event, maybe the OnExit property for a field which tests null; maybe the clicking of a button on the subform.

 

[jhsurti]

Set the visible property of the subform to False on the Click event of the button u wish to use for the purpose.
e.g.

.....
If Forms![subFormName].Visible=True Then
Forms![subFormName].Visible=False
Else
Forms![subFormName].Visible=True.
End If
...
...