puzzling user request

[JohnE]

I have a situation in which the users are asking for a change in how info is
displayed in a popup summary form form the original request for deposits.
Let me lay the ground work.

There is a mainform.

The mainform has a tabcontrol on it.

The tabcontrol has a subform on it. This subform has the many (items) to
the mainform's one.

On the subform is a button that displays the popup summary form.

The subform has a category field (combobox with value list) that is used to
indicate the what the item is (deposit, materials, labor, etc).

For deposits they enter the amt and the deposit category. This will show a
positive amt in the cost field.

There is then a deposit offset (negative amt) which is entered and also
given the deposit category. You're wondering why not use a deposit offset
category? I suggested this and it got shot down. They only want Deposit in
the category list.

Now in the popup form INSIDE the textbox for Deposit, they want it to show
$0 ($ plus deposit amt total / $ minus deposit amt total).

Currently, the popup is being filled when the button on the subform is used
to open the form. Using DSum as it was simple to construct with what they
originally requested. Currently, only the Deposit amt (positive amt only) is
displayed on the popup, which is what they originally requested.

I am at a loss on how to calculate and display what they are requesting. Or
if there is a better than the DSum method. Can anyone help on this?

Thanks... John

 

[Mike Painter]

The subform has a category field (combobox with value list) that is used
to
indicate the what the item is (deposit, materials, labor, etc).

For deposits they enter the amt and the deposit category. This will show
a
positive amt in the cost field.

There is then a deposit offset (negative amt) which is entered and also
given the deposit category. You're wondering why not use a deposit offset
category? I suggested this and it got shot down. They only want Deposit
in
the category list.

Now in the popup form INSIDE the textbox for Deposit, they want it to show
$0 ($ plus deposit amt total / $ minus deposit amt total).

Currently, the popup is being filled when the button on the subform is
used
to open the form. Using DSum as it was simple to construct with what they
originally requested. Currently, only the Deposit amt (positive amt only)
is
displayed on the popup, which is what they originally requested.

I am at a loss on how to calculate and display what they are requesting.
Or
if there is a better than the DSum method. Can anyone help on this?

Thanks... John

I don't see how you can avoid using more than one textbox, one to enter the
values and one to show the results.

What does this mean "$0 ($ plus deposit amt total / $ minus deposit amt
total)." ?
Are you dividing?

 

[JohnE]

I don't see how you can avoid using more than one textbox, one to enter the
values and one to show the results.

What does this mean "$0 ($ plus deposit amt total / $ minus deposit amt
total)." ?
Are you dividing?


.

That is actually not dividing but how they wanted to separate the different
amts. The info in the txtbox is not doing anything but displaying the
results. I thought there might be more than one txtbox involved so I'll need
to report back and let them know.
Thanks.