Results 1 to 2 of 2

Thread: Datasheet View

  1. #1
    Join Date
    Sep 2005

    Unanswered: Datasheet View

    I have a question.

    I create a button to open the form named "Check". I already created the Check form as Datasheet view, but when I click the button, it show out Form View. How can I fix that, I want to show Datasheet view.

    Please help.


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    The syntax for opening a form is:

    DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]

    with the "windowmode" section being the determiner of how the form opens. I suspect you've either got yours set to acWindowNormal, which is how it's opening, or you've left this arguement blank, in which case it defaults to acWindowNormal.

    You need to substitue the arguement acFormDS to get it to open in DataSheetview.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts