Writing current record to new table

[Guest]

This seems like it wouldn't be too hard, but for the life of me I can't think of a clever way to do this

I want a button on a form that takes the record currently being displayed and puts it in a table by itself. Every time the button is pushed the current record data is overwritten onto that table, which will always have one record

Seems easy, right? Any thoughts? Once I get it there I can export it and automatically fill out an Excel spreadsheet, which is my end goal

thanks
- S

 

[Immanuel Sibero]

Hi Stefan,

Just conceptually, you could execute an append query in the OnClick event of
your command button.
This Append query would simply insert a record into your other table using
the values from the fields on your form.

Are you trying to select certain records from a table and export them to
Excel?

You could add a flag field (with False default value) in your table and
while you're browsing through the records using your form, select the record
by setting the flag field to True. Then you would have a command button that
execute Transferspreadsheet based on a query that contains only those
records with the flag field as True.

HTH
Immanuel Sibero

This seems like it wouldn't be too hard, but for the life of me I can't

think of a clever way to do this.

I want a button on a form that takes the record currently being displayed

and puts it in a table by itself. Every time the button is pushed the
current record data is overwritten onto that table, which will always have
one record.

Seems easy, right? Any thoughts? Once I get it there I can export it and

automatically fill out an Excel spreadsheet, which is my end goal.