I need some help regarding a way of working please. Let me explain what it is I'm trying to do:
I have a form which displays the details of my products table, I have a separate text box on the form which shows the current balance of each stock item. So when I scroll through each product the text box keeps changing to show the current available balance. (this was all done with the aid of the wizards linking to a separate query so all is well at this point)
What I have done, is created a command button next to this text box which I would like to call "Details" when the button is pressed I would like access to go and "pull out" all the transactions, into and out of stock, which make up the balance shown.
What I have thought so far is the product code that is currently displayed should go into, and be held in a variable, I then need to open and display a query which extracts the movement in and out for this particular product code.
Now I have started my code as follows:
Private Sub cmdDetails_Click()
Dim str1 As String
Dim rs As Recordset
Dim dbs As Database
str1 = ProductCode.Value
Set dbs = CurrentDb
Set rs = dbs.OpenRecordset("qryTransactionSummary1", dbOpenForwardOnly)
To be honest this is where my knowledge begins and ends and I have no idea how I can do this.
Can anybody help?
I trust my explanation is sufficient