Adding data to a new record via a macro

[branston]

Hi,

I have a macro which deletes the information in a table and then runs an append query which imports 1 column of data to the, now empty, table. This is great, but I want to be able to add a new record every time it runs (e.g. "Add New").
I have found out how to add a new record, but i can seem to find anything on actually adding data to it.

Any ideas?

Thank you!