Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Textbox running an event (MS 2002)

    I have a parent form with many child forms in tabs associated by a Facility ID #. All works fine as far as the Facility ID # updating the subforms but I need to do an odd check. I need on the Tax sub form to to find out what state the facility is in then on the subform put in a text box the criteria of that state for taxes. i.e. If Facility "Y" is in state "CA" I need a text box in "Tax" subform to display "Taxes due November 1 and March 1st" and something different for another state.

    I for the life of me cannot get the "State" text box to trigger the "Tax" box in the sub form.

    I have tried this:
    If me.parent.State = "CA" then
    textbox.state.text = "Blah Blah Blah"
    End If

    But no go....any suggestions??

    Dan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Textbox running an event (MS 2002)

    textbox.state.text doesn't look like a valid reference to a control. What is the name of the text box on the Tax subform that is to display the specified text? And where do you call this code?

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Textbox running an event (MS 2002)

    textbox47 is the name of the textbox I am trying to update.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Textbox running an event (MS 2002)

    In fact, I think you would be better off creating a lookup table with two fields: State and TaxDue (or something like that), with State as primary key. You can then create a query that returns the correct TaxDue text; you won't need any code at all.

Posting Permissions

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