By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 2,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Filtered by form - differences between totals.

P: n/a
Hi All,

I would also like some help with form filtered differences in totals.

I have a main form for the client, and a continuous subform listing
client transactions. The subform can be filtered by several fields. I
have set up several text boxes which programatically show various
OnCurrent subtotal details depending on the filtered options in the
continuous subform.

I wish to populate one of the form footer subtotal text boxes with the
value of the difference between the highest and lowest amount as
currently shown in the field 'Volume' at any time.

I can produce a Max / Min value, but the OnCurrent calculation and
subsequent population of this text box is difficult - or is it?
Regards

Karl
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
After your min/max values are set have you tried to requery the text box?

Me.myTextBox.Requery

--
Reggie

----------
"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...
Hi All,

I would also like some help with form filtered differences in totals.

I have a main form for the client, and a continuous subform listing
client transactions. The subform can be filtered by several fields. I
have set up several text boxes which programatically show various
OnCurrent subtotal details depending on the filtered options in the
continuous subform.

I wish to populate one of the form footer subtotal text boxes with the
value of the difference between the highest and lowest amount as
currently shown in the field 'Volume' at any time.

I can produce a Max / Min value, but the OnCurrent calculation and
subsequent population of this text box is difficult - or is it?
Regards

Karl

Nov 13 '05 #2

P: n/a
Hi Reggie,

I'm sorry, I feel I made my question a little unclear.

I can write a separate query to get the Max / Min values of the field
'Volume'. I am unsure of how to integrate this with the current
records of the subform and get the difference of these values into the
subform footer text box.

Thank you for your time.

Regards

Karl

"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message news:<u9********************@comcast.com>...
After your min/max values are set have you tried to requery the text box?

Me.myTextBox.Requery

--
Reggie

----------
"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...
Hi All,

I would also like some help with form filtered differences in totals.

I have a main form for the client, and a continuous subform listing
client transactions. The subform can be filtered by several fields. I
have set up several text boxes which programatically show various
OnCurrent subtotal details depending on the filtered options in the
continuous subform.

I wish to populate one of the form footer subtotal text boxes with the
value of the difference between the highest and lowest amount as
currently shown in the field 'Volume' at any time.

I can produce a Max / Min value, but the OnCurrent calculation and
subsequent population of this text box is difficult - or is it?
Regards

Karl

Nov 13 '05 #3

P: n/a
Hi Reggie,

I'm sorry, I feel I made my question a little unclear.

I can write a separate query to get the Max / Min values of the field
'Volume'. I am unsure of how to integrate this with the current
records of the subform and get the difference of these values into the
subform footer text box.

Thank you for your time.

Regards

Karl

"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message news:<u9********************@comcast.com>...
After your min/max values are set have you tried to requery the text box?

Me.myTextBox.Requery

--
Reggie

----------
"Karl Roes" <ka******@hotmail.com> wrote in message
news:7c**************************@posting.google.c om...
Hi All,

I would also like some help with form filtered differences in totals.

I have a main form for the client, and a continuous subform listing
client transactions. The subform can be filtered by several fields. I
have set up several text boxes which programatically show various
OnCurrent subtotal details depending on the filtered options in the
continuous subform.

I wish to populate one of the form footer subtotal text boxes with the
value of the difference between the highest and lowest amount as
currently shown in the field 'Volume' at any time.

I can produce a Max / Min value, but the OnCurrent calculation and
subsequent population of this text box is difficult - or is it?
Regards

Karl

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.