Karen, try using a pair of DB Date/Time Pickers, and set the default
value on entry to the row, but only if the value is NULL. That way it
will keep the original values. I find that an eep on row entry works
best for this type of entry.
Albert
On 12/31/2014 9:15 AM, Karen Tellef wrote:
I don't do much with asking users to edit date/time, but I have an
application where I am going to default a date and time (default to
the same date, 2 hrs in the future) but I would like the user to be
able to change both the date and/or the time. I'm wondering how best
to structure the table (a DateTime column, or separate Date and
Time?), and what controls I can put on the form to make it the easiest
for them to change either. These wouldn't be power users so it would
need to be easy.
Thanks for the suggestions!
Karen
