Still having a small problem

[Noreene Patrick]

I posted a question last week in query section that SJ MCAbney answered for me. SJ suggested that I use an append query(which, by the way, does exactly what I need it to do) but still having a small problem.

So, here goes. Used a select query to open form by making deliverydate criteria as [Enter day of week]. It pulls out from my table all records with the day I enter...Works great. But, whenever I run the append query,(using a command button that also closes form) I have to enter the day again before it appends the data into the history table.

How do I keep it from asking for the day of week again? I can use it this way but it is being used by another user and I would really like to cut down on mistyping and unnecessay data entry.

Thanks, Noreene