Hide and Seek

D

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
 
R

ruralguy via AccessMonster.com

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

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"
???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top