Text box value

[nuttychick]

Default Value - date on a form

I have done this on another form and it works fine, a date is calculated 2 months from another date and the result is saved in the correct field in the correct table. However doing exactly the same on this instance does not work!

I have a pop up form that prompts for a new review date.

At the time the form is opened it creates a new record in my 'review' table for the 'problemID' concerned. This works fine.

I would also like the 'lastreviewdate' in the Review table to be updated at the same time.
The value of this 'lastreviewdate' needs to be whatever date is in the 'problem.initialreviewdate'.

I have created a text box on the form (Text21) and the control source is =problem.initialreviewdate
This works ok and provides the date
Now I added the field 'lastreviewdate' to the form and put the control source as 'lastreviewdate' and the validation rule as =[Text21]

When I do this however it doesn't provide the date, its blank.
If I change the control source to '=[Text21]' it shows the correct date, but how do I get this to save to the review table.????

HELP!!!

Thank you!

 

[Fizzio]

Rather than setting the control source of the form control to reference another control, set the control source to the field you want to save the data in and set the default value to the other form control.

 

[nuttychick]

Think I have tried this

My control source for the field 'Lastreviewdate' is set to Lastreviewdate
Default Value is set to =[initialreviewDate]

But when it is ran the field is still blank.


I have also tried this

my control source for the field 'lastreviewdate' is set to lastreviewdate
Default value is set to =[text29]

The control source for 'text29' is set to =[initialreviewdate]

Am I doing this wrong?

 

[Fizzio]

The default value will need to be a little more longwinded ie
=Forms!nameofForm!initialreviewDate

that should work