In the form design view I'm using the DateSerial function to generate a future date in a control based upon a start date entered into another control. I use the DateSerial function in the control source under control properties. However, when I do this the control is no longer linked to the table. How do I generate a future date and still keep the info linked to a table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
dateSerial
- Thread starter scottsbws
- Start date
What do you mean by "linked". Do you want to store a value that can be calculated in a control? Is the a good reason to do this? If so, you can bind the future date text box to the future date text box. Then use code in the after update event of the start date to set the value of the future date.
Again, this is rarely necessary.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Again, this is rarely necessary.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status