Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Unanswered: Linking Subform Problem

    Hello everyone. I have a dilemma that has bugging me for few months now, and I have decided to finally try something radical to solve it and could use your advice.

    BACKGROUND: Most of my database front-ends typically wind up with the same layout -- a main (parent) data entry form that has a tab control with multiple tabs on it and each tab has a sub-form (child). These subforms typically hold historic data or multiple instances to their parent. Sometimes they are the "Junction Table" in a Many-to-Many. A likely example would be a Customer (parent) form with OrderDetails, AddressHistory, OrderHistory, ActivityHistory, etc subforms (children).

    PROBLEM: While I love the ease and quickness of Access when developing, I have come to really despise "BOUND" forms and all that goes along with them. Yes, they have advantages, but the reality is they also have many shortcomings and furthermore no client/server database would ever use them (e.g. Oracle, Sysbase, and even SQL Server).

    QUESTION: Could someone please explain to me - based on the above example - how you could build a parent form with a tab-control and several subforms and be able to make it UNBOUND??

    So far i have ubound control on my main form which works find but i just don't know how to link my subform now.

    Im also attaching the database and i'm using ADO for connection


    Would someone please offer some wisdom and help here? It would be greatly appreciated!!!
    Attached Files Attached Files
    Skharva

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Short, General suggestion

    How about use a drop down on the form header, based on a query for record selection.

    On the after update event of this drop-down, populate the unbound controls on the form with the data relating to that record.

    Have a save button on the form so that when user has changed data, the onclick event of the save button writes the changes to your tables.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Re: Short, General suggestion

    Originally posted by garethdart
    How about use a drop down on the form header, based on a query for record selection.

    On the after update event of this drop-down, populate the unbound controls on the form with the data relating to that record.

    Have a save button on the form so that when user has changed data, the onclick event of the save button writes the changes to your tables.
    But how will i link my subform to mainform ? Do i need to make my subform unbound ? And after i make it unbound subform how do i link to main form ?
    Skharva

Posting Permissions

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