Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    16

    Loading the form with selected record


    Hello,

    I currently have many subforms in a form. I have a global varibale created when the item in combo box is selected. After selecting a record from a combo box. I want each of the subform to load with the selected record. I would like to go into each subform under "On Load" to pass the global variable to load that particular subform with the record. Is the right place to do it in? And if so how should that be done.

    I would do it with a Openform"doc name",,, 'where case'
    But how i have the general form set up, it isn't feasible ,so i just need to have each subform to load with the global variable ID

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Why not just use use Link Child Fields and Link Master Fields properties so that the subforms are linked automatically?

    Or are you saying that the subforms use the same table or query? If that is the case, I would change the design of your form...its really not a good way to go and could actually cause corruption under certain conditions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  2. Search for record from a form
    By hcoakley in forum Forms
    Replies: 0
    Last Post: 11-26-2006, 11:23 AM
  3. Form Record Count
    By Texaine in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 09:07 AM
  4. Slow Access Loading time
    By alexstoker in forum Access
    Replies: 3
    Last Post: 02-05-2006, 08:55 AM
  5. Loading pictures from URL in a report
    By drborracho in forum Programming
    Replies: 5
    Last Post: 12-13-2005, 09:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums