Auto fill date filed in form

[bradleyhorn]

Hi All,

I have a brain teaser. I ask the user fill in a date and then several fields in the form auto-fill with code similar to:

=[Forms]![SomeField]![Date1]+30

Since I have entered this code into the "Control source" property, it does enter the future date like I want it to, but doesn't write a date to the database when the form is saved. How would I get the date in the future to come up in the form field and also write it to the database? When I enter this code into the "initial value" property Access seems to ignore it.

Happy for any help,
Bradley

 

[txaccess]

If I understand correctly, the field is unbound and not linked to a table but is a calculated field. If you want it in a table, in the underlying table create a date field and when the user enters the initial date, use the DateAdd() function to increment the 30 days and populate the new field.

I haven't failed, I have just found 10,000 ways that it won't work!

 

[RezaNana]

yeah,bound it back to the original field.And under the form "On current" event,typer the code (something like this) me.somefieldname.value=date+30.

 

[bradleyhorn]

Thanks for the help,

If I was to use the Date() function where would I insert the code? Into the Initial Value Property?

If I was to use "me.somefieldname.value=date+30", I assume that I would click the (...) next to "On Current" Event and create a sub program?

Bradley

 

[txaccess]

Use the AfterUpdate event on the first field

I haven't failed, I have just found 10,000 ways that it won't work!