Results 1 to 4 of 4
  1. #1
    pleshrl is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2013
    Posts
    8

    pull data from a specific record in a subform


    I have created a form that contains information on a new product design. The main form has things like material, what equipment will make, who the designer is ...
    It has a relationship to a subform that tracks each time we try to produce it, information like trial number, trail date started, trial date stopped, trial tool number...

    What I want is to be able to get data from a specific subform record that meets a condition. There is a start date and stop date for each record in the subform. I want to build a query that will show me each new product design record (main form) and the start date from the record in the subform that does not have a stop date. This way I can see how long the current trial is taking for each main form record.

    Any thoughts?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Do you want your subform to be able to display both everything and only the 'current' trials (i.e. toggle back and forth)?

    If so there are a couple of ways you can approach this.

    The first, and simplest to me, is to change the record source of the subform when certain conditions are met (for instance someone checks off that they want to see current trials only in a checkbox).

    The second, is to try and apply a filter to your subform. I've always had issues doing this and prefer the first but either will get you the results you want.

  3. #3
    pleshrl is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2013
    Posts
    8
    The particular form I am trying to create, I only want to see the current trial.
    My issue was poorly described. I was actually trying to display a count of trial and information on the last run. Whenever I tried to filter to the current run and count, I would get information on each trial and a count of one.
    I had to make a total of three query's.
    1: Count the number of trials for each main record
    2: Pull the information I want on the current run by filtering
    3: Pull the summary (information from query 1 and 2) into this query.

    Ended up working fine.

    Am am not sure what you mean by change the record source of the subform. It has conditions that make it meet the criteria I am looking for. Would I change the data or the table or the query?

  4. #4
    pleshrl is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Apr 2013
    Posts
    8
    Actually it did not work. The real issue is still around, but has nothing to do with what I called this thread. So I am closing this one.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-19-2012, 01:52 PM
  2. Replies: 1
    Last Post: 08-01-2012, 12:50 AM
  3. Replies: 2
    Last Post: 02-22-2012, 02:36 AM
  4. Replies: 5
    Last Post: 12-22-2011, 11:01 AM
  5. Code to pull in data from a specific record
    By jdunn36 in forum Access
    Replies: 1
    Last Post: 09-20-2010, 11:54 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