Reference an open subform/query so its recordset can be copied into another location

[illicited]

I have a continuous subform whose source is a query that data is entered into. I'd like to program a button that copies the data entered and puts it into another table. Right now I'm having problems figuring out how to reference and store the fields on that subform into a variable in VBA. I'm not sure if there is a way to reference the open recordset of the subform or the query its based on or what. Help appreciated.

Thanks,

[June7]

Why do you need to copy data to another table? Sounds like duplication of data.

[illicited]

It's not, I just need to see an example of how to reference in VBA a subforms recordset or current field values.

[June7]

Depends where the code is. Is the button on the main form or is it within the subform? You want to copy entire record(s) or just selected fields of single record?

Does this help http://access.mvps.org/access/forms/frm0031.htm