Hello,

I'm new to access so pardon me if this seems like a dumb question, but i really need to know this
My problem is the following:
I have a table with for example two fields: one with a date and the other with a time.
let's say i have 5 records each with different dates and the time field is still empty. Now i want to enter data in the time field via a form but it has to happen like this: if i give in a time in the first record, for example 5 pm, then if i push a button every record has to get this time.
So 5 different dates but all with the same time.

I hope someone can help me with this

regards,

Harry

What you want is an update query. In SQL View, it would look something like this:

UPDATE TableName
SET TimeFieldName = Forms!FormName.ControlName

thx,

i'll give it a try