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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update table from calculated combo box 1

Status
Not open for further replies.

needlotsofhelp

Technical User
Apr 4, 2002
7
US
Dear Access Helpers,
I am a new user in need of help please!
I have a form based on a table called Training, on which I track training events accomplished and due.
I have a dateaccomplished combo and a datedue combo.
I am calculating the date due by putting =dateaccomplished+365 in the Control Source of the datedue combo box. My calculation is displaying the correct duedate on the form , but my duedate data is not being saved to the underlying table. The dateaccomplished does show up on the table. I need both to save to the table because I base reports of the table.
Will someone please help me? Any and all suggestions will be greatly appreciated!
 
This may not be the best solution but I would put in a textbox bound to the field DateDue and put on the After Update Property of dateaccomplished enter the code

Me!DateDue = Me!dateaccomplished + 365 Sandy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top