form view to datasheet

[deejay_totoro]

Hello,

I have a question that I think might also be useful to other users in this forum.

I have a continous form that shows many records. I have designed quite a complicated form but there are some occasions where it may be useful to see the form (same data) in datasheet view.

Apart from right-clicking and using the menu option, would it be possible to have a button that when clicked would allow the user to switch between continous form view and datasheet view?

One note: the form is is placed on a tab page.

Thanks!

dj_T

 

[ghudson]

This command will open the form in datasheet view.

    DoCmd.OpenForm "YourFormName", acFormDS, "", "", , acNormal

You will have to create a custom toolbar and use this command to open the form in the normal view since a datasheet can not hold command buttons.

    DoCmd.Close acForm, "YourFormName", acSaveNo
    DoCmd.OpenForm "YourFormName", acNormal, "", "", , acNormal