Can I append from a form instead of a table?

[KielWayne]

I have a form based on a query on Table A. I want to change the records on the form and append the changed records to Table B, leaving Table A in it's original state. I am fairly new to Access, and everything I have found so far seems to indicate that action queries are tied to tables only.

Thanks for any quidance in this.

Wayne

 

[scking]

Use a SQL INSERT statement.

INSERT INTO table [(column [, column...])]
VALUES (value [, value...])]

Steve King Growth follows a healthy professional curiosity