Form Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 31 Dec 2007 20:24 GMT

I have a command button on my form I use to look at the "Datasheet view"
after closing the datasheet it doesn't return back to the form it returns me
to the switchboard.

Private Sub Command23_Click()
On Error GoTo Err_Command23_Click

DoCmd.OpenForm "frmScanlog", acFormDS
Exit_Command23_Click:
Exit Sub

Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

End Sub

Thanks for your help.

Reply to this Message

Adien - 31 Dec 2007 20:33 GMT

I believe since the datasheet veiw of the form is just another way to
see the form, when you click the cmd button it doesn't open a new
instance of the form, it just alters the one you have.

Reply to this Message

Richard - 31 Dec 2007 20:45 GMT

ok so can I add code to the button to reopen the form when I am finished with
the datasheet view?

> I believe since the datasheet veiw of the form is just another way to
> see the form, when you click the cmd button it doesn't open a new
> instance of the form, it just alters the one you have.

Reply to this Message

Arvin Meyer [MVP] - 31 Dec 2007 20:56 GMT

Use the same code, but leave off the datasheet view (acFormDS)

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> ok so can I add code to the button to reopen the form when I am finished
> with
[quoted text clipped - 3 lines]
>> see the form, when you click the cmd button it doesn't open a new
>> instance of the form, it just alters the one you have.

Reply to this Message