Open a form in either continuous or single record view

  • Thread starter Thread starter Mary Fran
  • Start date Start date
M

Mary Fran

How do I open a form in either continuous record or single
record view depending on the choice made by user in
previous form? Thanks in advance for your help.
Mary Fran
 
How do I open a form in either continuous record or single
record view depending on the choice made by user in
previous form? Thanks in advance for your help.
Mary Fran
Click to expand...

You can only change the default view of a form in design view.

How is the user going to select which form view?

Add an Option Group to the first form.
As Option1 label caption write "Single Form"
Option1 valus is 0.
As option2 label caption write "Continuous View"
Option2 value is 1

Code a command button event:

DoCmd.OpenForm "FormName", acDesign
Forms!FormName.DefaultView = Me!OptionGroupName
DoCmd.OpenForm "FormName"

When you close the FormName form you will be asked whether or not to
save the change.
 
Back
Top