Default Values On Forms - why does one impact another?

[mhoctober]

Strange one this...



On an order taking form I have two controls one based on a field OrderTakenDate and the other based on a field OrderDeliveryDate.

I want to use the values from the control OrderTakenDate in queries to see when orders have been taken (date/time), however when I set its default value in the form to Now() ... to record the date/time the order was input... it works fine apart from the fact that this also forces any entry in the control OrderDeliveryDate to also hold a time value (as well as a date), and there are a number of reasons why I don't want this to happen.

I dont see any connection between the two fields either at form, query (that the form is based on) or down at table design.

Anyone any ideas or have seen anything like this before??

Thanks

Mike

[pbaldy]

Not sure what you mean by "forces". How are you entering data there? A date/time field always holds a time value, though it could be zero. Date/time fields are stored as a Double, where the integer portion represents the date and the decimal portion represents the time.

[mhoctober]

Got it! Thanks...your reply made me think......the two controls are 'linked' in that the orderDeliveryDate is populated when the user clicks a button L to make its date 1 higher or E one date lower than the orderDate. So if the orderDate's value contains a time that is something other than zero the orderDliveryDate eill also.

Thanks pbaldy. This has been nagging me for a while. Strange how its often so easy to miss the obvious!

[pbaldy]

Happy to help.