Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform refuses to come up as datasheet view (97)

    Subform refuses to come up as datasheet view

    I have a button that activates a subform but whenever the subform pops up it

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform refuses to come up as datasheet view (97)

    Is there a chance that you are over-riding the settings on the form by using the acNormal argument in the code that is opening the form?

    You may be using something like this:

    DoCmd.OpenForm "YourFormName", acNormal ...... ect

    In the example above the "acNormal" will force the form to open as a "Normal form". You can either remove the "acNormal" from the line or change it to "acFormDS" to force the form to open in Data Sheet view.

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform refuses to come up as datasheet view (97)

    <P ID="nt"><font size=-1>(No Text)</font>

Posting Permissions

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