Copy Detail line from one Form to another Form

  • Thread starter Thread starter tag
  • Start date Start date
T

tag

I want to copy the Detail line records from one Form to
the Detail line of another Form. How can I do that ? My
access version is 2000.

Thanks
tag
 
why would you want to do that?
you could use an SQL statement to insert the row to the other form's source
table
or you could use a recordset...
 
Thanks for your reply.
If I use recordset, could you provide me with an example.

Thanks again.
tag
 
I want to copy the Detail line records from one Form to
the Detail line of another Form. How can I do that ? My
access version is 2000.
Click to expand...

BIG concern here:

A Form DOES NOT CONTAIN ANY DATA.

A Form *is just a window*. Your Form displays data from a Table; it is
not a repository for that data. The window in my office 'contains' the
Owyhee Mountains, but I can't step through it and start hiking!

If you want to display the same data on another form, simply set that
form's recordsource to display the same records. If you want to copy
the detail records, storing them redundantly in another table, you
should probably reconsider! It is VERY rarely a good idea to have the
same data in two different tables.

Step back a bit and describe the business problem which you are
attempting to solve here. It might be that an Append query, copying
the data being displayed on one form into a table, is the solution
you're asking for - but I very much doubt that it's actually the
solution you need!
 
Back
Top