Textbox running an event (MS 2002)

Topic

New Reply

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

Reply | Quote

Replies

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?

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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?

Reply | Quote