Hi There,
Access 2007 - Win7
I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table
When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the current month.
I know that the built-in date picker cannot be manipulated
I cannot work on check-out default value because it will not be updated on the current record
The only way that I've found until now is to set the check out value to check in + [some days] but I do not like it because it could generate data entry mistakes
How can I solve? If there is no way to get the job done with the built-in date picker, what kind of ActiveX control could I use instead? And where to find it?
Many thanks in advance for any kind of help
Carlo
Access 2007 - Win7
I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table
When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the current month.
I know that the built-in date picker cannot be manipulated
I cannot work on check-out default value because it will not be updated on the current record
The only way that I've found until now is to set the check out value to check in + [some days] but I do not like it because it could generate data entry mistakes
How can I solve? If there is no way to get the job done with the built-in date picker, what kind of ActiveX control could I use instead? And where to find it?
Many thanks in advance for any kind of help
Carlo