Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Datasheet Subforms (2000)

    Hi all,

    Hopefully this is a simple question with a simple solution. I have created a datasheet subform that I would like to put into another form. However, when I did that and customized the page header/footer (i.e., added buttons, text boxes, etc) when I view it in "run" mode, all you see is the datasheet subform and none of the headers or footers.

    Is there something that I need to turn on in either form's properties?

    Thanks!
    Kindra

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet Subforms (2000)

    Kindra

    What you are describing is Access default making of a subform from a table.
    This is ok for showing just data.
    If you want a subform which contains buttons and stuff, you'll need to take the other option on creating the subform:

    "Use an existing form"

    Of course you'll have to make your form first an then select it from the Wizard's listbox containing all your forms.
    Once you have the form inside the main form, you can mess with the sizes etc until it meets your requirements.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Datasheet Subforms (2000)

    Thanks Dave!!!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Datasheet Subforms (2000)

    As Dave wrote, a datasheet just shows data, nothing else. Open the subform in design view and set its Default View property to Continuous Forms. If you wish, you can arrange the controls in the Detail section to make the form resemble a datasheet view, while still showing the header and footer sections.

Posting Permissions

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