Help! I'm relatively new to access.

I have set up a form that I use to look up records from a query. The fields on the record are populated when data is chosen from a listbox. No problems so far.

Now I'm trying to copy the record from the form to a different table which I have set up for that purpose. I want to be able to click the command button and populate a new record in the other table.

Anyone have some pointers for me? I've been looking for some very descriptive code, or at least sql, but I am fairly unfamiliar with it to a degree. Help would be enormously appreciated from a good samaritan.

Its possible you could use a macro to run an append query. Assign the on click of the command button to the macro.

[This message has been edited by arickards (edited 10-04-2000).]