|  | 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
|
|
| |
|
|