Question Date Picker problem

[Susie]

Hi all and hello to everyone,
I am new to Access (and this forum) and using Access 2002. I have managed to develop a database for my small business and am feeling very proud of myself. However, on fine tuning I would like to introduce a Date Picker for ease of use. I have a Check in Date and a Check out Date. At the moment they are working perfectly using the Date/Time field. I want to change that field to a datepicker. I have found out how to insert the date picker and it works great when inserted on a new record BUT all the previous dates in the database change to the current date. Is there a way I can still display the previous dates in the field and also introduce a date picker?? (without having to manually change everyone)

Sorry if this is a silly question. Thanks your help would be appreciated.

 

[GinaWhipp]

I would not use the Date Picker, instead use...
http://allenbrowne.com/ser-51.html
...this will help as you can never be sure is all your Users will have the correct version. The above one travels with the database.

 

[Susie]

Many thanks Gina, I will give this a go, this way I see I can keep the original text box and field. Thanks again

 

[GinaWhipp]

Yes, you can and you're welcome!

 

[ntyler1]

Thanks for the link. Will try as well.