Using an append query in a subform

Joined
Jan 23, 2014
Messages
3
Reaction score
0
I am creating a checklist to be filled in and have designed a form with a subform.
I have a table with a list of tasks to be completed on several different machines.
I also have a table to enter the information into.
I want to be able to open the form and in the main form enter user, date and machine then move to the subform and have the list of tasks brought over to the subform then be able to check the completed box and entered notes.
What is the best way to do it I have tried macros, query and append queries and am now starting to pull my hair out. Please help
 
Joined
Jan 23, 2014
Messages
3
Reaction score
0
Ok so I have now created a form with a subform
The subform has all the fields in it that I need filled in 7 in total
I have created a query which pulls all the info I need filled in (first 5 fields)
I can auto fill the fields when I change the first field
(I get a drop down list showing all the records from the query)

The only problem is I have to do each row manually.... How can I get this to work automatically when I change the first field?
 

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

Top