How to unhide a specific form or database window in A97?

I used this line in A2.0 to unhide the database window:
DoCmd.DoMenuItem A_FORMBAR, 4, 4, 0, A_MENU_VER20
Although it will work in A97, it will also unhide anything else
that's hidden on each successive run.

Is there a more specific command syntax to unhide a
given form (or the database window)?

re: How to unhide a specific form or database window in A97?

MLH wrote:
[color=blue]
> Is there a more specific command syntax to unhide a
> given form (or the database window)?[/color]

Forms!frmName.Visible = True

To hide, Forms!frmName.Visible = False

Not sure about the database window. I wouldn't bother to allow any
users access to it.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

re: How to unhide a specific form or database window in A97?

Thx Tim.

re: How to unhide a specific form or database window in A97?

Tim provided answer on unhiding forms, but was
not sure about a better syntax for doing same to
database window. Anybody else wanna take a
stab at it? Looking for something less nebulous than

DoCmd.DoMenuItem A_FORMBAR, 4, 4, 0, A_MENU_VER20

The above line, I'm sure, is a little outdated.

re: How to unhide a specific form or database window in A97?

MLH wrote:[color=blue]
> Tim provided answer on unhiding forms, but was
> not sure about a better syntax for doing same to
> database window. Anybody else wanna take a
> stab at it? Looking for something less nebulous than
>
> DoCmd.DoMenuItem A_FORMBAR, 4, 4, 0, A_MENU_VER20
>
> The above line, I'm sure, is a little outdated.[/color]

It's already been stabbed to death :-). You didn't look very hard.
The first three hits of: unhide database window
had solutions for this. For instance,

http://groups.google.com/group/comp....d1e8fc9?hl=en&

James A. Fortune

re: How to unhide a specific form or database window in A97?

Thx James. SelectObject is the way to go.