Change Form view 1

[tekkyun]

A really simple one I'm sure......

I have code which opens form in form view, then changes recordsource and displays results.
All I want to do is switch view mode to print preview after changing the recordsource.

If I open form in preview mode (using docmd.openform formname, acpreview), then I can't switch recordsource.

Can I switch view by docmd.domenuitem method?

 

[tekkyun]

I think I've answered myself.
It is easy.

This seems to work....
DoCmd.RunCommand acCmdPrintPreview

but could I do same with docmd.domenuitem?

 

[Eupher]

Hi, tekkyun,

I have a strong bias against domenuitem - I've never had much luck with it, it's too dependent on the version and what menu items are displayed. RunCommand is much more reliable.

Ken S.

 

[Eupher]

p.s. I just did a quick check, and the MS website confirms what I thought I remembered... DoMenuItem was officially replaced by the RunCommand method in Access 97 - it is only included in later versions for backward compatibility.

Ken S.