Form Question

[Richard]

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.

 

[Adien]

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.

 

[Richard]

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

 

[Arvin Meyer [MVP]]

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