Subform like combo box

  • Thread starter Thread starter JACK GUNAWAN via AccessMonster.com
  • Start date Start date
J

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
 
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.
 
Al said:
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.
Click to expand...


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
 
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.
 
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
 
Richard said:
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.
Click to expand...


Thanks, I will try.


Jack
 
Back
Top