Hi,

I can get a button to open a form and get a button to close a form.

Thing is, I want the button to open one form and close itself...if that makes sense?

eg form1 has a button on it.
When clicked, I want to open form2 and close form1

I've tried using the forms LostFocus property and also tried putting the close form code in for the button all to no avail...

Any suggestions?

Cheers,

nry

DoCmd. OpenForm,"Form2
DoCmd.Close "Form1"

Didn't work for me....the new form loaded but the original form didn't close...possibly because it lost focus?

Anyhow, after a bit of searching I used the 'IsOpen' function from the Northwind Database.....

nry

I know there is no error handling, but in this case I would use a simple macro. Macro's rule!

Scott
(At work, but very, very bored ....)

Since your bored, why not convert your macros to vba include error handling and avoid the Blue Screen Kiss Of Death?