Copying a record to a table or report.

[Ricky1946]

Hello,
I want to be able to select a record from a datasheet or form and, on clicking a button, copy that record into a table or a report to create a suppliers order from a list of materials shown under that suppliers filter.
Any suggestions as to how to do this?
I prefer this in VBA but SQL will do.
Thanks in advance.
Ian Richards "To say 'thankyou' encourages others."

 

[mac318]

Use SQL's "Insert Into" method. Microsoft Access help will give you some excellent examples.

mac

 

[Ricky1946]

Thanks Mac318,
I will give it a try.
Regards
Ian "To say 'thankyou' encourages others."