Hi All,
I am new to your forum and I am a beginner programmer in VB and VBA. I am working on a small inventory control system and I and kind of a stuck on this particular problem, so here it is:
I have a search form and it is suppose to search and filter the criteria I enter from the text boxes and combo boxes and display the resulted query on the sub form (datasheet view). From the filtered results I want to select the product from the shortlist and add it as a new record in the "purchase order details" table with a click of a command button. moreover, I want to add an extra field of "quantity" to the "purchase order details" table with the selected data from the product search query.My knowledge of Access and VBA programming limited, Please Help.