I am using Access 2003. I am using a comand button in a form to open another
form which I have created in Datasheet format. This form opens correctly
from the Database Window, but when I open it using the command button it
opens in Single Form format. What am I doing wrong?

Colin Hammond

DoCmd.OpenForm "FormName", acFormDS

--
Joan Wild
Microsoft Access MVP
"Colin Hammond" <(E-Mail Removed)> wrote in message
news:eur0b9$h8j$1$(E-Mail Removed)...
>
> I am using Access 2003. I am using a comand button in a form to open
> another form which I have created in Datasheet format. This form opens
> correctly from the Database Window, but when I open it using the command
> button it opens in Single Form format. What am I doing wrong?
>
> Colin Hammond
>

Hi

Can you post the code behind the button

--
Wayne
Manchester, England.



"Colin Hammond" wrote:

>
> I am using Access 2003. I am using a comand button in a form to open another
> form which I have created in Datasheet format. This form opens correctly
> from the Database Window, but when I open it using the command button it
> opens in Single Form format. What am I doing wrong?
>
> Colin Hammond
>
>
>

Thanks very much for your help.
Colin
"Joan Wild" <(E-Mail Removed)> wrote in message
news:u17c$(E-Mail Removed)...
> DoCmd.OpenForm "FormName", acFormDS
>
> --
> Joan Wild
> Microsoft Access MVP
> "Colin Hammond" <(E-Mail Removed)> wrote in message
> news:eur0b9$h8j$1$(E-Mail Removed)...
>>
>> I am using Access 2003. I am using a comand button in a form to open
>> another form which I have created in Datasheet format. This form opens
>> correctly from the Database Window, but when I open it using the command
>> button it opens in Single Form format. What am I doing wrong?
>>
>> Colin Hammond
>>
>
>