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

Hi,
try:

DoCmd.OpenForm "YourForm", , , , , acHidden

OR

DoCmd.OpenForm "YourForm"
Forms!YourForm.Visible = False

HTH
Good luck

acHidden did it, thanks so much.

You're welcome.
Good luck on future projects!

Freak,

I had 'forgotten' about the acHidden, I was thinking about something along those lines other day.
So you got a bonus for your post today.

Aqua