automate new entries

[angie]

i have a query with the following fields (and data example): payment (= phone
bill), deadline (= 30/11/07), effective by (= 28/11/07), amount (= 200),
increment days (= 30) and duplicate entry (= yes).
i want to create a form that when i select the value yes in the duplicate
entry field i will have an automatic insertion of (based on the above stated
example):
payment=phone bill, deadline=30/12/07 (because increment days value=30),
effective by=deadline value, amount=200, increment days=30 and duplicate
entry=no.
can i achieve something like that and if yes how?

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

You may be able to use an Append query that uses the query as the source to
append data into the desired table.