I created an order entry/inventory tracking program. The main user form will select an item from a combo box , enter a
qty and that number will be deducted from the Qty in Stock.
In addition to that, the user can push a command button to
view that item's details, which is on another form called Item Description.
What I want to achieve is for the user to see all past transactions involving that ItemID. I have it working, but it won't show the current record. After I exit the program and come back, the records are refreshed. The subform that the transactions are based on is based on a query.