Hide and Seek

[DS]

If I do this
Form!frmOne.Visible = True
Forms!frmOne.ListOne.Requery
Forms!frmListOne = Null
Forms!frmOne.CommandHide.SetFocus
DoCmd.Close acform, "frmTwo"

frmOne never reappears. However if I do this...it does! Is this a bug or
perhaps.......

DoCmd.Close acform, "frmTwo"
Form!frmOne.Visible = True
Forms!frmOne.ListOne.Requery
Forms!frmListOne = Null
Forms!frmOne.CommandHide.SetFocus

I've tried this with several forms and always the same results....
Any insight would be appreciated!
Thanks
DS

 

[ruralguy via AccessMonster.com]

Did you mean to write: FormS!frmOne.Visible = True
instead of: Form!frmOne.Visible = True

 

[DS]

Yes I did.
DS

 

[ruralguy via AccessMonster.com]

So the sequence that does NOT work is:

Forms!frmOne.Visible = True
Forms!frmOne.ListOne.Requery
Forms!frmListOne = Null
Forms!frmOne.CommandHide.SetFocus
DoCmd.Close acform, "frmTwo"
???

 

[DS]

Correct. It does not work.
DS