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...

"tag" <(E-Mail Removed)> wrote in message
news:080201c37c03$767a52a0$(E-Mail Removed)...
> 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

Thanks for your reply.
If I use recordset, could you provide me with an example.

Thanks again.
tag

>-----Original Message-----
>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...
>
>"tag" <(E-Mail Removed)> wrote in message
>news:080201c37c03$767a52a0$(E-Mail Removed)...
>> 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
>
>
>.
>

On Mon, 15 Sep 2003 20:34:41 -0700, "tag" <(E-Mail Removed)> wrote:

>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.

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!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public