How to move a value from a query into a table or form?

[Demonic]

Hello,



Under the Service Info Tab, I am trying to add the amount of weeks in Weeks Paid to the Start Date to self generate the Transition Date.

I got my formula to work in the Transition Query but now want it to show in the Accounts Form in the Service Info Tab in the Transition Date.

I need help in either moving the Transition Date value from the Transition Query to the Accounts Transition Date Table or just having the Transition Date value from the Transition Query showing in the Transition Date box in the Service Info Tab in the Accounts Form.

Hope this makes sense.

Can anyone help me?

Thanks!

[June7]

Have the calculation in the ControlSource of Transition Date textbox:

=[Start Date]+[Weeks Paid]*7

Set the textbox TabStop property to No.

[Demonic]

Got it! Thanks! but now how do I make that value be saved in the accounts table in the Transition date column?

Thanks for all the help June 7!

[June7]

Saving calculated values is usually not necessary and can even be a bad idea. One example of bad is a person's calculated age. This data gets stale quickly. Calculate a person's age when needed.

Same can be done with your data. Calculate when needed.

If you must save then need code. If the Transition date field is part of the form's RecordSource, could be simple as:

Me!Transition = Me.tbxTransition

Or

Me!Transition = Me![Start Date]+Me![Weeks Paid]*7

The trick is figuring out what event to put the code in - perhaps the Close event of the form.