Limiting Date Values User Can Choose

[adrienne_r30]

I have a field that shows dates as quarters. Right now it is just a date/time field, but that posses a problem, as the user can enter any date possible. I want the dates to be limited to March, June, September and December, and any year they choose. Can someone please help me with this. I tried fooling around with the input mask and the validation, but I just couldn't figure it out.

Thanks in advance

 

[plog]

Did you look at jdraw's advice?

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

If that won't work for you, post back there and explain to him why it won't.