Good day all.
I'm trying to input data from a calculated bound text box to a table (called tblPlayerContract (primary key is called [PlayerContractID]). This text box is in "date" format and is called [DateExpired] (obviously, this is also the name of the column in the table that I want the result to go into).
The calculation is adding the number of years to another date (the # of years control is called [ContractLength] and the date it's added to is called [DateStarted]).
The expression I'm using is =DateAdd("yyyy",[ContractLength],[DateStarted]). All of these controls are on the same subform (subfrmPlayerContract).
I've been reading about the use of the "Insert into" function but not sure how I can use it with what I'm trying to do.
Thanks for your help in advance.