Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Cool Unanswered: Forms and Subforms

    I am trying to put a subform into a form.

    1. The subform comes as a blank wite form.
    Q. How do i change the design of it from Datasheet?

    2. In the subform link properties, Ikeep getting
    ' Can't link between unbound forms'
    Q. Why?

    I am pretty new to the world of Access, so I hope these questions are not to basic.

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    The subform comes as a blank wite form.
    Typically, that's a result of the subform returning no data. The may also not be a form associated with the subform object (see my next comment).


    How do i change the design of it from Datasheet?
    You should have a form that correspons to the subform - you can see which one it is by checking the SourceObject property of the subform control.

    Open the form by itself and check it out. You can design the suborm to look anyway you want. One of the form properties is called ViewsAllowed, which may be set to Datasheet. Change it to Form or Both (the default of Both is Form).


    In the subform link properties, Ikeep getting ' Can't link between unbound forms'
    That's the way it is - Access does not let you link parent to child in unbound forms.

    What are you trying to do - I'm sure there's another way to do it.

    Note: I'm basing this on Access 97 - newer versions may be different.

Posting Permissions

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