switching Datasheet / Form view

[NH]

I have a form which is opened from a custom menu bar.

The form is set to datasheet as default view, and datasheet is the only view
enabled....

When I open the form using the menu, it opens fine, but if I then if I
attempt to open it again (I.e. had forgotten it was already open, or want to
give it focus), it then switches to Form view, which SHOULD be disabled??

Is Access supposed to act in this way?
Is there any way I can prevent this??

Thanks,

Nick

[Van T. Dinh]

In the second instance, you probably use the OpenForm Method with default
View (acNormal) which will open (or activate) the Form in (normal) Form
view. VBA code will override the Form's settings.

Check Access VB Help on the OpenForm Method and specify the appropriate
value for the View argument.

--
HTH
Van T. Dinh
MVP (Access)



"NH" <nhNOSPAMPLEASE@trada.net> wrote in message
news:u9RRJaTTDHA.2676@TK2MSFTNGP10.phx.gbl...

> I have a form which is opened from a custom menu bar.
>
> The form is set to datasheet as default view, and datasheet is the only

view

> enabled....
>
> When I open the form using the menu, it opens fine, but if I then if I
> attempt to open it again (I.e. had forgotten it was already open, or want

to

> give it focus), it then switches to Form view, which SHOULD be disabled??
>
> Is Access supposed to act in this way?
> Is there any way I can prevent this??
>
> Thanks,
>
> Nick
>
>
>