Using an append query in a subform

S

Saldridge

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
 
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?
 
Back
Top