I have taken a few folks advise and created a date field that defaults to todays date and a time field that remains an enterable field on the form. However, I still need to have the date/ time field as I have multiple queries(hundreds) based on it so I am looking to this group for an answer-
On the form or the table, how wouled I combine the dat field and the time field so that it defaults to the date/time field.
I have tried setting the default value for the field in the properties as
=[forms]![fdetailbyfacility]![arrivaldate].[arrivaltime]
Of course this does not work. Any suggestions? The arrival date and arrival time field are entered first, how do I default the date/time field to these two???
Thanks
On the form or the table, how wouled I combine the dat field and the time field so that it defaults to the date/time field.
I have tried setting the default value for the field in the properties as
=[forms]![fdetailbyfacility]![arrivaldate].[arrivaltime]
Of course this does not work. Any suggestions? The arrival date and arrival time field are entered first, how do I default the date/time field to these two???
Thanks