Re: Entering Year as part of a macro

I believe I understand what you are trying to do. Before you continue,
would you mind describing why? I ask because folks sometimes figure they
have to move records (or persons) from one table to another, and this is
rarely necessary.

Since you have dates involved, is there a chance you are working with
"archiving" information? If so, be aware that one way to archive is to
simply add a DateArchived field, then change the queries that look at that
table to exclude the "archived" rows. This gives the "current" rows.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"SamDev" <lauranoble@xxxxxxxxxx> wrote in message
news:RGsKf.5531$%14.233353@xxxxxxxxxxxxxxxxxxxxxxxx
In a form I have a combo box that users can select a client. After
selecting
a client the user clicks the OK button. The OK button I have set up the
event that it will run an append query and then a delete query. It appends
the selected client to a new a different table and then deletes selected
client from source table.

I want the user to be able to enter the year of the deletion (I have this
field in both original & destination tables), after the client is selected
and before the queries are run. A pop-up box would be nice. I can't seem
to
figure out how to get Access to allow me to enter the year before it
starts
running the queries.

Any help would be appreciated...much thanks!



.