Add current record to another form

[James T.]

Using Access 2000

I have a TBL of descriptions and a Form based on that TBL.

I am looking for a way to have the user click a button
that will add the current record he is looking at to a
different form that will accumulate records to prepare an
estimate.

Any help or guidance appreciated.

Thanks,

James

 

[Rick B]

Records can't really be 'added to a form'. They live in a table.

What I would recommend is using a continuos form where you can scroll
through records meeting your criteria. You will need to add a 'marked'
checkbox to the table. When the user finds a record to add to your list,
simply mark it. Then, you can either perform some function using a button,
or have a different form that selects records that have been 'marked'.

You need to make sure to unmark them (either manually or through code) when
you are finished with them.

Another way would be to set up a one-to-many relationship where you tie
specific records to an 'estimate number'.

Rick B

Using Access 2000

I have a TBL of descriptions and a Form based on that TBL.

I am looking for a way to have the user click a button
that will add the current record he is looking at to a
different form that will accumulate records to prepare an
estimate.

Any help or guidance appreciated.

Thanks,

James