Data Entry in Forms from a Query

[Tam]

I am trying to append data from a main form/subform into a different table.
What is the best way to append the results into a table? My main form is
calling from a query and the subform is calling from a data table, forms
linked by question group category. No problem getting filtered results and
then have user put answers against questions in the subform, but i need both
main/subform data posted to a results table for specific individual case.

 

[Guest]

hi,
the only way i know of is either an append query or a
recordset. I've use both. Append query would be easiest.
less coding. it would have to mimic your filtered results
+ include what your usere input. user input after filter i
guess would be the tricky part.
Post back if have questions.
p.s. I may be limited. i don't use bound forms.

 

[Tam]

Hi,
I have mimiced the criteria as an append query and it seems to work
beautifully as a stand alone append query, because i actually hard coded the
linked id's in the table that the subform calls. But when the Form opens in
form view after selected client id & category ID for both main/subform these
id's don't seem to stay into the field specified in the forms in order for me
to create a command button that would duplicate the append query to save the
record and put into the results table.

What do you suggest there?

hi,
the only way i know of is either an append query or a
recordset. I've use both. Append query would be easiest.
less coding. it would have to mimic your filtered results
+ include what your usere input. user input after filter i
guess would be the tricky part.
Post back if have questions.
p.s. I may be limited. i don't use bound forms.