Code to change a Default Date

[JReichnan]

Hello all,

I would like to be able to change the default date in a table or the related form by posing an input box and having the user select the new default date. What is the code that can get the user input date into the Table or Forms Default property. Thanks. Jeff

 

[Robert88]

Hi JReichnan,

I have performed a default combo box to update a table, not a date but it should work for dates as well.

http://www.access-programmers.co.uk/forums/showthread.php?t=103048

Hope it helps, felt like I was having a convesation with myself in the link.

Robert88

 

[JReichnan]

Very interesting code. Id like to spend some time analyzing it. Thank you.

 

[Robert88]

Hi JReichnan,

No Problems. Worked a treat for my combo boxes and thier default tables, I supose you just have to address the date variable and all the rest should be the same.

Have fun with it.

Robert88

 

[JReichnan]

Thanks Robert88....very interesting code. I can use this for a number of applications Im working on. later brother. Jeff

 

[Robert88]

Hi JReichnan,

I am glad it has helped, I myself find this site is very helpful. In retuurn it is the least I could do.

Robert88