Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Access subform

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 4 posts

I'm working on a db for teachers to enter results of a test (problem by problem) where the results can be analyzed by each problem (which is linked to a learning standard)

I have these tables set up with these fields (I'm not listing all the fields.. just the ones that I think you need

TEST Table:
- TESTnum
- TESTname
- TESTprobs (number of problems on the test - I just added this field today because I think it might help)

- PROBtest (part of multiple key with PROBnum)
- PROBnum
- PROBstd (links to Standards table - not really part of my current question!)

- ACHkey (an autonumber key, for these transactions)
- ACHstudent (student number, links to student table)
- ACHtest
- ACHprob
- ACHieve (this is the actual "y" or "n"... how the student did on this problem on this particular test)

So here is my question:
I would like the Form where teachers enter the actual test results to display a subform with the exact number of records for the particular test. I have it set up so they select a test (a combo box - it works! ) .. then they select the student (it works!).. but then the subform just shows 1 record - of course, I haven't done this part yet. I would really like it to show 10 records, displaying just ACHprob and ACHieve, where ACHprob is prefilled with the numbers from PROBnum depending on the Test that is selected.

I hope I have explained this well. Thanks for any help you can give me.

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP