Dates and times

[bjackson]

I have a form where the user has to select a date then select a time for
a specific task to be done.I want to store this value in 1 date/time field in a table, but am having trouble joining the two values together to form a valid
date.
The date TxtBox on the form has its format set as long date,and the time TxtBox format is medium time.
Can anybody help

thanks in advance

 

[WayneRyan]

bjackson,

You should just be able to:

Me.DateTimeField = Me.ShortDate & " " & Me.LongTime

Wayne

 

[bjackson]

Thank you Wayne, that works
i had used Me.DateTimeField = Me.ShortDate & Me.LongTime, i didnt realise
it needed the space in between the 2 values