is it possible

  • Thread starter Thread starter Georgge
  • Start date Start date
G

Georgge

Is it possible to append records from a subform in
datasheet view to another table by using append query. The
point is that subform returns values from a select query
and the user adds or edits some values and wants to keep
these values in another table.

Any ideas?
 
Is it possible to append records from a subform in
datasheet view to another table by using append query. The
point is that subform returns values from a select query
and the user adds or edits some values and wants to keep
these values in another table.

Any ideas?
Click to expand...

A Subform DOES NOT CONTAIN ANY DATA.

It's a window onto data in a Table (usually with a query as an
intermediary). If the user is entering or editing data on a subform,
that edited data is being stored in a table.

You can run an append query from that query into any other table - but
you cannot append "from a subform"!

You may want to review the design with some care - it sounds like you
may be storing data redundantly.
 
Back
Top