writing fields to another table

[Dan]

Hello,
My function is selecting certain fields from selected
records in an access table. Can I have the function write
the fields to a new access table? Sounds odd but I've
received an odd request.
Thanks for any and all advice.
Dan

 

[John Vinson]

Hello,
My function is selecting certain fields from selected
records in an access table. Can I have the function write
the fields to a new access table? Sounds odd but I've
received an odd request.

You'll need to open a Recordset based on the target table; to create a
new record in said table, use the AddNew method. Open the VBA editor
and look at "Recordset" and "AddNew" in the help, or post back.

 

[HSalim]

nothing odd, and very possible.
If you post your code (sanitized if you like)
and give us more details, many here will be able to assist you in this

HS