Prefill records based on form entry

A

Alex

Hi,

I believe that I need to use a macro for the following.

I have a form based on test_attempt table which shows test_id, student_id,
test description, date.

Then, command button on form pulls up another form. This second form (QA)
is based on a query of tables Questions and Answers. The Answers table is
empty because the student has not yet answered the questions! (The answers
table links to the questions table on question id). The questions table
filters on the test description on the main form (so only those questions
relevant to a particular test show up- this part is working well).

What I need to do...have the answers table prefill with records to show the
student ID and Test ID from the main form, but leaves the answers field
blank, for data entry.

Would a macro be the correct procedure to use here?

If so, can anyone help me with the code? I have not used macros before.

thanks,
Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2013: Form problem in reading data tables; relationship one-to-one 0
QBF & Query Malfunction 0
Searchforrecord does not appear to work 4
Fill information in form based on other form 2
Getting data from the form to the tables 8
Need help in creating macro 0
Pull information from subform 10
Save Linked tables values in form based table 2

Top