Append Query: Time Stamp

[AKQTS]

Here is waht I am trying to accomplish:

When a button is pressed, the current time is inserted into a field in a table.

How I am trying to accomplish this:

INSERT INTO Cleaning_Batch_Parameters ( Cleaning_Time_In )
SELECT Time$() AS Expr1
FROM Cleaning_Batch_Parameters
WHERE (((Cleaning_Batch_Parameters.pkOrderBatchID)=[Forms]![Dashboard]![Dashboard_sub]![pkOrderBatchID]));

This query is on a macro that is opened once a button is pressed.

I am getting a key violation everytime I run this though.

The appropriate fields are referenced to input the value into the correct record on the table. The table field the time is inserted to is set to text (I don't know if that matters).

[pbaldy]

Are you trying to create a new record (row)? That's what that code would do. I suspect you want this:

UPDATE Cleaning_Batch_Parameters
SET Cleaning_Time_In = Time()
WHERE pkOrderBatchID=[Forms]![Dashboard]![Dashboard_sub]![pkOrderBatchID]

[AKQTS]

Thanks it works. Thread marked solved

[pbaldy]

Happy to help!