Writing information to a new file

OK I am a little stumped. I am working on a dispute database.

I have a main data table which users update via a form. On this form I have
a number of push buttons that run macros.

One push button runs a macro that A) sends an authorisation request email,
B) updates the date and time of authorisation request on the form and on the
main data table. As users can change the type of "dispute" hence the
authorisation needed another macro then resets all the date information to
"null" if this is done. What I need to do is keep a record of all work done
on a dispute (each authorisation request, each authorisation, each rejection
of authorisation. To do this I have set up another table which I am using an
Append Query to populate with the dispute number and an autogenerated
incremental task number. However now I'm stuck - I can only get the append
query to create the record and update the dispute number and the auto
generated task number, when I try to get it to append other fields from the
main data table into the other table it won't work - any ideas anyone?

Is there an error or a message? Do you have the fields set up with correct
data types. Are you sure the info your passing isn't null(are you setting the
dates to null before the append query)? To help more you should post the
update SQL and table set up.
--
HTH
Martin J


"KB" wrote:

OK I am a little stumped. I am working on a dispute database.

I have a main data table which users update via a form. On this form I have
a number of push buttons that run macros.

One push button runs a macro that A) sends an authorisation request email,
B) updates the date and time of authorisation request on the form and on the
main data table. As users can change the type of "dispute" hence the
authorisation needed another macro then resets all the date information to
"null" if this is done. What I need to do is keep a record of all work done
on a dispute (each authorisation request, each authorisation, each rejection
of authorisation. To do this I have set up another table which I am using an
Append Query to populate with the dispute number and an autogenerated
incremental task number. However now I'm stuck - I can only get the append
query to create the record and update the dispute number and the auto
generated task number, when I try to get it to append other fields from the
main data table into the other table it won't work - any ideas anyone?