writing fields to another table

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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.
Click to expand...

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