HIde Form from another form

[bluegnu]

I have a form which has a button on it which opens another form. When this happens I want to be able to hide the form with the button on it, but I can't work it out.

I have used forms![Myform].visible = false and that doesn't work.

Any help is appreciated.

 

[JerryKlmns]

bluegnu, before you open then new form, set the current form unvisible

Me.Visible = False

and then open TheNewForm you want

DoCmd.OpenTable TheNewForm, acViewNormal, acEdit

 

[bluegnu]

Is it possible for this to work in the OnLoad event. I can get it to work on the button OK, but I'd also like it to work on the Onload. I have an If/Then query which I'd like it to work with. The If statement opens the other form if the value of a field is greater than one, but when I put the Me.Visible = False in the If statement as well, it doesn't work.

 

[JerryKlmns]

bluegnu,

You open form1, the if statment checks a field of the returning query if it is grater than 1 and on true hides form1 and shows form2???

Why don't you do the check before loading any form and then choose which form(1 or 2) to show?!

 

[bluegnu]

OK. When the database opens a form is opened with the date on. This form then checks to see if more than one user is logged in. If only one user is logged in they are asked to check the date because the PC's they use aren't necessarily on the correct date.

If there are more than one user logged in the form opens the main search form and should go hidden because I want that date form to stay in the background as it is used in many other form fields.

But what happens is, the search from is opened, but the date form also remains visible and on top.

Any ideas?

 

[bluegnu]

Don't suppose anyone can help with this?

many thanks

 

[belairbrian]

is the date form set to modial?

 

[bluegnu]

I was originally, but I changed that. I just can't work out why it isn't working.

I'm using Access 97 in case that is of any significance.

 

[jazzz]

Try your code in the On Current event. To hide the form.

Life's a journey enjoy the ride...

jazzz

 

[mgmslate]

If you want to make the first form visible try using Forms(0).Visible = True in the onload event in your second form.

Mike