Can I do it without any reference to specific fields, as the fields can
change and I don't want to remember to come back and change the insert query
every time?
Thanks
Regards
<pi********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Umm... create a select query that grabs the record you want. Probably
point it to the open form.
Turn that into an append query so that it appends to the same table
that it's looking at.
In your form, bookmark your record (if you want to return to it), shut
off your warnings, run query, then turn warnings on again, and return
to bookmark. (or you could go to the last record...)
Sorry. Access != Excel.