Date Time Data Entry

[lburgoyne]

I have a database with 2 date/time fields, [DueDate] and [CompleteDate].
I am looking for a way to make the fields on a form act as two seperate fields, one for the date and a second for the time. I have tried having two separate text fields linked to the same date/time field, with one formatted as a date and one formatted as a time, but this has not worked properly.
I cannot modify the existing fields, but I can add additional fields if necessary.
Any thoughts would be greatly appreciated.

[hedges98]

I'm just thinking out loud here and am by no means an expert but couldn't you do something like the following:
For DueDate, have that on your form...
Then two text boxes, txtDate and txtTime. Format txtDate to Short Date and txtTime to Long Time.
Change both of their AfterUpdate events to something like

Me!DueDate.Value = Me!txtDate & " " & Me!txtTime

And it should add the correct information to the DueDate textbox. In theory anyway.
There's almost definitely a better way to do this and I'm not sure if that will bring about an error but it might be worth playing around with something like that

I'm sure an actual expert will wade in and come up with a better solution now!

[nico5038]

Besides setting the DateTime field after an update as described by hedges98, you'll also need to fill the fields in the form's OnCurrent event.
Personally I would place the (bound) DateTime field on the form but set the visibility to "No".

Nic;o)