View Single Post
  #1 (permalink)  
Old June 9th, 2003, 05:44 PM
shepston shepston is offline
Authorized User
Join Date: Jun 2003
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do I Unhide a Form?

I am using two different forms to open a third form. For simplicity, lets say FormA and FormB have buttons to open FormC.

Here is the problem. When I open FormC from either FormA or FormB, the first Form is hidden:

    [code from FormA]
    DoCmd.OpenForm "FormC", acNormal, , "Key=Forms!FormA.Key"
    Forms!FormA.Visible = False
    [code from FormB]
    DoCmd.OpenForm "FormC", acNormal, , "Key=Forms!FormB.Key"
    Forms!FormB.Visible = False

That part is simple enough but the problem comes when I close FormC. How do I unhide the appropriate form?

When I use the following code, I get error if FormC was opened from FormB:

    Forms!FormA.Visible = True

Any help would be appreciated.
-Shay Shepston