I would like to display the calculated field result from a query in a text box on the form

I have a Training details form which has a control, Training_Date text box and then a combo box Frequency which has a number of set days.  This is calculated in the query and I would like to have the result displayed in the form control Due_Date once the choice from the combo box is chosen.
This will then allow the value to be recorded in the table allowing for reports and queries on training due.  
I have tried a number of methods without any luck as yet.

Cheers
MichaelState HSEQ ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
You can do it in after update event for your combo box. Something like:
Me.[Due_Date] = Dateadd("d", [Frequency], Datevalue([Training_Date]))

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MichaelState HSEQ ManagerAuthor Commented:
Many thanks for the reply
I placed your code in the update event for cboDue_Date and it still didn't work, I then put the Control Source for txtDue_Date as =[qryTraining Query]![Due_Date].  I am now displaying #Name? in the text box.

This is the code in the form module.

'Code to display calculated field from Training_Query in form

Private Sub cboFrequency_AfterUpdate()

 Me.[txtDue_Date] = Dateadd("d", [cboFrequency], Datevalue([txtTraining_Date]))
 
End Sub

Cheers
als315Commented:
May be you can prepare sample DB with this form and some dummy data in table?
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

MichaelState HSEQ ManagerAuthor Commented:
Hi als315
I have attached the database with some info though please excuse the errors as I am trying to fix them with another expert from this forum as we speak.

When you open the database if you close the error message and double click frmPPS_Training_Register the tabbed form will open and then click on the Training Details tab to see the Due Date text box.

Many thanks for your help.

Cheers
PPS-Employee-Training.accdb
als315Commented:
Look at sample. txtDue_Date field should be bounded if you like to store it in table. Change cboFrequency and you will see changes
PPS-Employee-Training-1.accdb
MichaelState HSEQ ManagerAuthor Commented:
Many thanks als315
The changes work well and update immediately allowing the user to view before saving the record.

Cheers
als315Commented:
Michael! You didn't select any my comment as an answer, so it will not be marked as a solution and no points will be assigned to it.
als315Commented:
I propose to select comment #a41715737 as an answer
MichaelState HSEQ ManagerAuthor Commented:
Sorry for the mix up.
I accept #a41715737  as the solution.

Cheers
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.