Change already opened form view to datasheet?

[Guest]

We have several forms where Single Form view is fine for adding or editing a
record, but if we then want to view all the records at once it is much better
to use Datasheet view.
Generally we do want the forms all to open in Form view by default. However
it would be very nice to have a command btn on the form so that we could
switch to Datasheet view (and, I guess, back again) whenever we wanted.
Hope somebody knows how???
Many thanks
CW

 

[fredg]

We have several forms where Single Form view is fine for adding or editing a
record, but if we then want to view all the records at once it is much better
to use Datasheet view.
Generally we do want the forms all to open in Form view by default. However
it would be very nice to have a command btn on the form so that we could
switch to Datasheet view (and, I guess, back again) whenever we wanted.
Hope somebody knows how???
Many thanks
CW

To open a form in datasheet view from a Command button:
DoCmd.OpenForm "FormName", acFormDS

Or..
while the form is already open in Single Form View, press Alt + VS
To go back, press Alt + VF

 

[Guest]

Fred -
Many thanks for the quick response. Great advice, as usual.
I quite like the hot key approach, and I guess I could put a little prompt
on the forms until people get used to/remember the shortcuts.
One thing occurred to me - if I did use the cmd button method, how could I
put anything on the datasheet for the return action (back to form view)?? Is
it even possible to do this??
Thanks again
CW

 

[fredg]

Fred -
Many thanks for the quick response. Great advice, as usual.
I quite like the hot key approach, and I guess I could put a little prompt
on the forms until people get used to/remember the shortcuts.
One thing occurred to me - if I did use the cmd button method, how could I
put anything on the datasheet for the return action (back to form view)?? Is
it even possible to do this??
Thanks again
CW

Read VBA help on the DefaultView property.
"Users can't switch from Datasheet View to Form view" (.... using
VBA).

Alt + VF will work