allen brownes audit trail

[jomara via AccessMonster.com]

I am using Allen's audit trail to keep a history of changes to my database.
Everything works great when updating from a form. My problem is i have an
update query that is used to move a contact to another sales person. My
query has 4 fields 1:Contact staus (updates to new lead) 2: rep (manually
enter new rep # to update to) 3:lead box (unchecks the box talking it out of
leadbox) 4: update lead (only moves the leads that are checked ) I would
like to change update lead from a yes/no box to a text box and enter the rep
number there so allen's audit trail would keep track of those changes is this
possible. I hired someone to help with my database and before i go back to
them i would like to try this on my own

 

[Allen Browne]

Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.

 

[jomara via AccessMonster.com]

i am new to programming how would i go about using the where clause

Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.

I am using Allen's audit trail to keep a history of changes to my database.
Everything works great when updating from a form. My problem is i have an

[quoted text clipped - 10 lines]

to
them i would like to try this on my own

 

[Allen Browne]

You have a query that runs your update?
Open that query in SQL View (View menu in query design).
Look at the query statement.
It consists of an UPDATE clause, SELECT clause, a FROM clause, a WHERE
clause, etc.

You need a similar WHERE clause in your INSERT query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

i am new to programming how would i go about using the where clause

Execute a 2nd query (an append query) to write the values to the logging
table, using the same WHERE clause so you get the same records.

I am using Allen's audit trail to keep a history of changes to my
database.
Everything works great when updating from a form. My problem is i have
an

[quoted text clipped - 10 lines]

to
them i would like to try this on my own