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 SkipVought 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 calculate combo box?

Status
Not open for further replies.

needlotsofhelp

Technical User
Apr 4, 2002
7
0
0
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!
 
Storing calculated Dates is considered bad practice, it can be calculated at any time using a query or calculated control on a form/report to display it.
 
Dear RichUK,
Thanks for you advise. I am learning a lot just by reading the forum posts! I am not too familiar with queries. How do I go about it?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top