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