The "button that goes to" a form does not "go to the form". It is the Click
event code for that button that opens a Form -- the code generated by the
Command Button wizard will include a DoCmd.OpenForm statement. One of the
arguments of that statement determines the mode in which the Form will be
opened, and that argument _overrides_ what you specified for the Form
itself.
On the properties sheet for the Button, use the Events to open the code for
the Click event, place your cursor on the OpenForm statement, and press F1
for Help to determine the setting to open the Form in the mode you prefer.
Larry Linson
Microsoft Access MVP
"Dave" <da********@hotmail.comwrote in message
news:11**********************@l77g2000hsb.googlegr oups.com...
>I have a simple little purchase form, on it is a button that takes the
user to a suppliers form .
The purchase form has a default view set to single form, and the
supplier form has a default value set to datasheet.
When I click on the button that goes to the supplier form from the
purchase form, the form changes into a single form view and not the
datasheet view set for it.
How can I stop this from happening so when I click the button in the
purchase form that goes to the supplier form the views stay the same
int hat there settings I set do not change.
