General Question

drhat77's avatar

How do i make it so entering data in a top form places a calculated value in the sub form?

Asked by drhat77 (6197points) July 13th, 2008

I have two table, Main, and Calc. they are both keyed to field “Reference”. Main has a field called “Data”, and Calc has a field called “Data_calc”. I have made a form off of Main, with a nested sub form out of Calc. I want to make it so that entering a number into Data results in a calculated value being placed into data_calc. I have made the following epression in expression builder in the After Update property field of the text box controlled by Data:
=Child4.Form!data_calc=(-0.64)([data]-125)([data]-150)
Child$ is the name of the sub form in the main form.
needless to say, it doesn’t work. Does anyone know how i can make it work?

thanks

BTW there are asterisks between the three parenthesied expressions, but fluther turns them into bold!

Observing members: 0 Composing members: 0

1 Answer

nina's avatar

You could put the calculated field in one of the tables and then display it in the subform, that would require refreshing the form though.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther