Update a table from a form with a subform

[vaiism]

I have attempted using both Updata and Append Queries to solve this problem, and I can't seem to get it to work.

I have three forms that each have an ID#, and a subform with related scores to questions. In the subform I have a textbox that sums the scores, and a field that stores the date the scores were obtained.

What I want to do is to store the ID#, the date and the score summation from each of the three forms into a table. This should be done automatically if possible, like once the form is closed a query will run and update the table from the form.

I have tried to use criteria in the query to update the table with the appropriate data from the form using the [Forms]![Form Name]![Data Point] format, but this only works on the main form or only on the subform with a dialog box coming up for the other form depending on which data point in place furthest to the left in the Query Design View.

I think I have a solid idea of what I need to do, but I am getting caught up in the nuances of running the query and the criteria.

Any help would be appreciated.

Thank you

[JConsulting]

I have attempted using both Updata and Append Queries to solve this problem, and I can't seem to get it to work.

I have three forms that each have an ID#, and a subform with related scores to questions. In the subform I have a textbox that sums the scores, and a field that stores the date the scores were obtained.

What I want to do is to store the ID#, the date and the score summation from each of the three forms into a table. This should be done automatically if possible, like once the form is closed a query will run and update the table from the form.

I have tried to use criteria in the query to update the table with the appropriate data from the form using the [Forms]![Form Name]![Data Point] format, but this only works on the main form or only on the subform with a dialog box coming up for the other form depending on which data point in place furthest to the left in the Query Design View.

I think I have a solid idea of what I need to do, but I am getting caught up in the nuances of running the query and the criteria.

Any help would be appreciated.

Thank you

A code solution using the form's on_close event may give you what you want.

example:

currentdb.execute "Insert Into yourtable ("datefield","otherfield","otherfield") values ("& me.myformfield1 & "," & me.myformfield2 & "." & me.myformfield3 &")
 
 

J