|  | Command button opens as form view want Datasheet view | | |
| | | matjcb |  |
|  Posted: Wed Sep 17, 2008 11:03 am Post subject: Command button opens as form view want Datasheet view |  |
I have a start up menu with a command button linked to a form as “open form”.
The form was created to open as “Datasheet view”.
But, when I push the command button, it opens as “Form view".
Is there a way to have the button open as "Datasheet view" also?
thanks
--
JB |
| |
| | | Linq Adams via AccessMons | |
| | Posted: Wed Sep 17, 2008 11:19 am Post subject: Re: Command button opens as form view want Datasheet view | |
When opening a form from another form, you have to explicitly tell Access to
do this in Datasheet View, even if the form's Default is Datasheet:
DoCmd.OpenForm "YourForm", acFormDS
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
LINK |
| |
| | | matjcb | |
| | Posted: Wed Sep 17, 2008 2:04 pm Post subject: Re: Command button opens as form view want Datasheet view | |
It worked...awseome thanks
--
JB
"Linq Adams via AccessMonster.com" wrote:
| Quote: | When opening a form from another form, you have to explicitly tell Access to
do this in Datasheet View, even if the form's Default is Datasheet:
DoCmd.OpenForm "YourForm", acFormDS
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
LINK
|
|
| |
|
|
