Hello All,
I have built a database for ordering parts and as soon as i receive parts i then check the box called received and it takes that entry away from the form and keeps it in the table, however i want the received orders archived from the date they were checked on.

I am using 0 criteria for the checked box field which basically removes it from the form but keeps it in the table however i want another field to have a date/time added as soon as the box is checked.

I hope i am making sense.
I have tried several ways of making a on click event but i cant get the code to work right.
Any help would be wonderful

Thanks
Attached is my database

You need to add a textbox to your form called, for instance, ReceivedDate, formatted as a date. In the Properties box set its Control Source as RecievedDate. Then in VBA code enter:

Private Sub Recieved_Click()
Me.ReceivedDate.Value = Now()
End Sub

When you click on the Recieved checkbox the date will be placed on your form and in your table.

Private Sub Recieved_Click()
Me.ReceivedDate.Value = Now()
Me.Requery
End Sub

Thanks to Missinglinq and Myle for the prompt reply!
I went ahead and createda field called ReceivedDate properties set to shortdate and after placing that code to onclick event of the received checkbox and it work flawlessly.

You guys are just awsome, i know i can always count on you.
thanks again

I have one more question, How do I enter a comment such as " Are you sure you want to received that order" before it executes the command?

Thanks again

try some like

Thanks Myle!
that worked just fine