Results 1 to 2 of 2
  1. #1
    pecro is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010

    Link to alternate table without a subform

    Alright, so I am fairly computer savvy, not completely new to Access, however still not very advanced at it. I will mention right away that I have no experience with VB code, and would prefer to use macros for now if possible.

    That being said, here is my problem. I have a main table of students with student ID being the key along with additional information on the student (name, address, etc.). I then have a second table for tests. The fields on that table are "TestType", "TestScore", "TestDate", and "PreOrPost". So there are different types of test each student could take and they can only do one pre test and one post test.

    I have a form to put student info into the main table, that was easy enough. I can make a subform to put test info in for each student, but this allows for putting in multiples of the same test.

    Since there are only a fixed number of different tests, is there an easy way I can make a text box for say, Test1Pre and Test1PreDate and once the user fills those boxes in, it would automatically populate the test table with the following: "Test1", Score input, Date input, "Pre" (following the field names mentioned above)? I would then create more text boxes to do the same for Test1Post, Test2Pre, ...

    I hope that makes sense, and thanks for the help!

  2. #2
    pecro is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Oops, I forgot to mention that Student ID would be a foreign key in the Tests table.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-06-2010, 06:30 PM
  2. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM
  3. Link table using MAC PC file sharing problem
    By TaiYipStreet in forum Access
    Replies: 0
    Last Post: 07-19-2006, 08:02 AM
  4. link excel form to access table
    By data123 in forum Import/Export Data
    Replies: 6
    Last Post: 06-23-2006, 10:17 AM
  5. Import/Link Pictures into a table
    By shm138 in forum Import/Export Data
    Replies: 3
    Last Post: 03-17-2006, 08:12 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