Full Version: Hide a form
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
river6
How do I hide a form? I have a command button on my form that opens a form (runs a query). I have set an unbound box on my form to display the results (total) of the query which is the only control on the form, and another to add the amount from this text box to the amount the user has entered (this is to determine if the new entry puts the member over the monthly limit). I don't store the values, it is just a check for the data entry person. I don't want the form that runs the query to get the monthly total to show when the user clicks the command button, I just want the totals to show. How can I set it to open on click, but not really be seen?
thanks!
river
freakazeud
Hi,
try:
oCmd.OpenForm "YourForm", , , , , acHidden
OR
DoCmd.OpenForm "YourForm"
Forms!YourForm.Visible = False
HTH
Good luck
river6
acHidden did it, thanks so much.
freakazeud
You're welcome.
Good luck on future projects!
Aquadevel
Freak,
had 'forgotten' about the acHidden, I was thinking about something along those lines other day.
So you got a bonus for your post today. frown.gif
Aqua
freakazeud
thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.