Subform like combo box

[JACK GUNAWAN via AccessMonster.com]

Hi, I can not figure out how to make a subform but hide like a combo box,
where appears only when needed cause the form is already crowded. Thanks

Jack

 

[Al Camp]

Jack,
Well, you could hide it completely by using the SubformName.Visible = False/True
Or, just change the SubformName.Height = some short height/some tall height
Try a Toggle button to initiate the code.

Note... this code would be on the main form, and refer to the subform "object" on that
main form. This would not be done from "within" the subform.

 

[JACK GUNAWAN via AccessMonster.com]

Jack,
Well, you could hide it completely by using the SubformName.Visible = False/True
Or, just change the SubformName.Height = some short height/some tall height
Try a Toggle button to initiate the code.

Thanks Al, i think the toggle button would help. I will try. About the
counting printed reports, is there any solution. As the code Al gave me
takes a long time to run on pentium 4's.
In addition, I am using access as a pos system and different report contain
different item list( increment sales id), so that the counted report code be
used to count the number of times the same report with the same item list was
printed so as to reduce shrinkage due to double or multiple printings.
Thanks/

Jack

 

[Al Camp]

Jack,
Well, how you decide to intitiate the Show/Hide or Grow/Shrink code is your decision...
the point being that Show/Hide would use the Invisible property and Grow/Shrink would use
the Height property.

As to Counting Prints, I responded to your latest post in the Reports NG.
Please stay with that post... if we run out of answers, you can always repost.

 

[Richard W. \(Rich\) McCabe]

Jack, What happens if you set the combobox.visible = True/False to false.
Then make the combobox visible with a togle button. Hitting the button a
second time would hide the box after you are done with it.
Rich

 

[JACK GUNAWAN via AccessMonster.com]

Jack, What happens if you set the combobox.visible = True/False to false.
Then make the combobox visible with a togle button. Hitting the button a
second time would hide the box after you are done with it.

Thanks, I will try.


Jack