Inventory Item Totals by Transaction with Inventory Balance displaying on form

[ssalem]

I am new to Access 2007. I do have some programming knowledge but have to research most of what I do because not to familiar with Visual Basic.

I have a database of Stamp Inventory. What I am trying to accomplish is to create a form that displays totals of different dinominations of Stamps by a specified Category used by a combo box. I have a query built to run the totals by the combo box selection. The problem I am having is I also want to display on the form the balance of each dinomination of stamps.

I have tried creating a sub form which totals all the denominations of stamps by transaction type and display stamp balances for all transactions types. I tried using a Dlookup from a subform. But not having any success. Not sure what I am doing wrong.

Table Name: Stamp Inventory
Query Name: Query Transaction Totals (combo box query)
Form Name: Form Stamp Balance (just for totals based on another query)


So in my form I am trying to set my criteria for a unbound text box to " =Dlookup("Stamp Inventory","Stamp_01","criteria = " & Form!Form Stamp Balance!Stamp_01

Not sure if I am even trying to tackle this in the right way or not.
any suggestions or help would be appreciated.

Thanks

[burrina]

Do you have a combobox on this form? If so just use it to populate your fields. And then for your textbox use something like [yourfieldname].Column(3)