Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update unbound textbox after parameter set (Access 2002)

    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

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update unbound textbox after parameter set (Access 2002)

    This function may be of use.


    <A target="_blank" HREF=http://www.aldex.co.uk/codesamp.html>Which Financial Year is a date in? </A>

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •