I need to call the date time picker value which is DTpicker1.VALUE into my macro... I have tried using me.dtpicker1.value and it doesnt work due to improper use of me... can someone tell me how I can use this value in the filename in my macro... So I need it to be Open Order Report + Dtpicker.Value as my filename so whatever date they salect it goes next to open order report in the filename... Thanks for any help...!!!