Performing calculations using data from multiple ListBoxes and Multiple tables

[Scot Niklos via AccessMonster.com]

Sorry if it is way to much information but I'm trying to cover all bases
Access 97

A= combobox that queries Distributor
B= combobox that limits customers by distributor in a
C= combobox that shows equipment inventory at b

OriginalVAL= query that extracts original $ amount from INV table based on matching EquipmentID seleced in C (currency)(listbox)(unbound).

BTA = query that calculates total amount for all $ transactions for equpipment matching EquipmentID in BTAADJUST Table (currency)(listbox)(unbound).

New = User entered value to adjust equipment $ value (currency)(textbox)(unbound).

All the above function as intended.

ADJENTRY = BTA-NEW does not

I'm trying to subtract NEW-BTA to get the resulting $ adjustment to post into the BTAADJUST Table. But I am unable to get the calculations to work, I just get a blank control. I'm assuming that I'm not actually populating the listboxes with the data from the queries, and that is why the calculations do not work. I've tried setting the value of ADJUSTENTRY in the forms vb secion ADJUSTENTRY=bta.itemdata(0)-new which does not work either. I'm not completely sure if I should even be passing this data to a listbox, or if there is an easier way to handle this. (I'm self teaching)
Any help would be appriciated.

--
Message posted via http://www.accessmonster.com

[pietlinden]

>From the sound of things, you have the Multi-select property of the
listbox set to true, and you can't query the results directly. You
have to OR together the values in the ItemsSelected collection.
There's code for this right here... see if this solves your problem:
http://www.mvps.org/access/forms/frm0007.htm

[Scot Niklos via AccessMonster.com]

I see where the code is going but I'm not mutiple selecting from the listboxes (flag is set to none). I'm using them to show the query results because I need to show the end-users the values. I was just trying to use the values already queried and do the calculations on the form directly. I'm assuming that I'm not containg the query results correctly.

Maybe I'm going about this wrong. Can I contain the query results in any other type of control but a list/combobox?

--
Message posted via http://www.accessmonster.com