Carry over date from previous record

[yeasir01]

I build a form where you enter a date, click submit which takes you into another form to enter all the other required information. To grab the value from the first form I set the default rule as followed =[Forms]![Date]![DateSelect]

Once I make my date selection I would like to keep it until I change the date manually or close the form out. but every time I add a record I get #Name error.

I have searched all over and tried different codes w/no success. Is there anyone who can help me?

 

[mbizup]

<< =[Forms]![Date]![DateSelect] >>

1. Change the default value to:
= getFilteredDate

2. Place the following function in a standard module (not in your form's module or any other class module):

Function getFilteredDate
getFilteredDate = Forms![Date].DateSelect

End function

3. Verify that the form and control names are indeed correct. The general syntax here is:
Forms!TheNameOfYourForm!TheNameOfYourTextBox

4. Is your form really named "Date"? If so it would be best to change it to something else, since Date is a VBA function/reserved word. Use a name like frmDateFilter instead.