Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Hide and Seek

0 views
Skip to first unread message

DS

unread,
Oct 7, 2008, 10:52:25 AM10/7/08
to
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

unread,
Oct 7, 2008, 1:30:42 PM10/7/08
to
Did you mean to write: FormS!frmOne.Visible = True
instead of: Form!frmOne.Visible = True

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200810/1

DS

unread,
Oct 7, 2008, 2:30:23 PM10/7/08
to
Yes I did.
DS


ruralguy via AccessMonster.com

unread,
Oct 7, 2008, 6:26:13 PM10/7/08
to
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 wrote:
>Yes I did.

DS

unread,
Oct 7, 2008, 10:30:25 PM10/7/08
to
Correct. It does not work.
DS


0 new messages