I tried to add a button "Close Form" on to a form which I want to have datasheet view. I could not find the button after changing from Design View to Form View. What is wrong?

Thanks in advance for any suggestion,

L.X.

You can't add things to datasheet views.
If you need to, you'll have to settle for making your form look similar to datasheet view by making it in Continuous view.

Either that, or make it a subform of a larger Single form and add the buttons to the main form.

I am a loud man with a very large hat. This means I am in charge

Thanks for your quick response.

Is the Continuous View the same as Tabular View? If not, how to create the continuous view?

Thanks again,

LX

I found the answer. Thanks again.

LX

You can paste this code in your on Open Event Procedure:
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_OpenoForm_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Your form name"
    DoCmd.OpenForm stDocName, acFormDS

Exit_OpenoForm_Click:
    Exit Sub

Err_OpenoForm_Click:
    MsgBox Err.DESCRIPTION
    Resume Exit_OpenoForm_Click

End Sub

OR you can paste it in a command button. The key is the form's name and "acFormDS" the view type.

In matters of style, swim with the current. In matters of principle, stand like a rock. Thomas Jefferson

-------\\\|///
--------(oo)
--oOOo-(_)-oOOo--

It's interesting. I'll try.

Thanks,

LX