Update unbound textbox after parameter set (Access 2002)

Topic

New Reply

This is what you call learning by the seat of the pants.

I have a report that has theer parameters that are filled in as the report opens. No problem there. One is the month written out i.e. November. Once that value is placed in its unbound textbox I want another unbound textbox to use the November, or the value there, to be the base of the answer for the second textbox.

Lets see if this is clearer. Fiscal year runs July to June. They have a goal of 8.3 percent of the total workload for the year to be completed each month. I want a text box to show that since it is November there should be 41.65% complete. If it was January it should show 49.98%. I am assuming that I would have to write an If…Then…Else statement. But I am not sure where to put the code. Would it be in the AfterUpdate even for the Form.

Thanks for all your help. Fay

Reply | Quote

Replies

This function may be of use.

Which Financial Year is a date in?

If you deal with financial data you will probably need to calculate which tax or financial year a particular date falls into.
The following function will return the Financial Year for any given input date.

Not exactly what you asked! Hope its of some use.

Reply | Quote