Open new form from main menu

[Gregory23]

Hello ,



I would like to two questions about the main menu

• How to set main menu to open a new form (e.g : last form was 001 and would like to fill out a new form when click Enter order form)
• How to make button that opens up a unique form for editing
• How to set up to print the form on one page / scale to a single page

Appreciate any help

Thank you

[CJ_London]

1. you have one form - 001 will be the value of a field on the form. Google the use docmd.openform - in particular look at the openargs parameter. Also google 'dmax+1' to find way of incrementing a number

2. same answer as above

3. difficult, forms are not intended for printing, but if that is what you want to do, ensure the form is no larger than the paper you want to print to. Not possible to scale. Print is usually done through reports but these also need to sized to fit what you are printing to.

[Gregory23]

Hello Ajax ,

Thank you for the support