Yes/No

[combine21]

I have a query in which when the check box is selected, that record it is automatically sent to another query. Is is possible to to put the date in which it was sent to the second query in the second query in another column?

[pdebaets]

The record is never actually "sent to a query". A query is simply a view of records in an underlying table.

Are you perhaps referring to an append query which adds records to another table?

[combine21]

I guess? Im still new at all this stuff. I need for the date in which the yes/no is selected to appear in the appended query.

[pdebaets]

OK, that's different. You need another field in your table (the same table that holds the Yes/No field). You can name this new field "DateSelected" or some such thing. The data type should be "Date/Time". Add the DateSelected field to the same form as the Selected check box (I assume you have the Selected checkbox on a form, yes?) Then in the AfterUpdate event procedure of your Yes/No checkbox put the following code:

DateSelected = Date()

Now in your query, include DateSelected along with your Yes/no checkbox field in the list of fields selected.