I created a main form with a datasheet subform that includes 4 fields: ID, Product, MinimumStock, StockOnHand. Subform record sources are from a query.
I now want to add a checkbox field onto the form, so the user can select products that are under minimum qty and then by clicking a button on main form to generate a Production Order of records ticked.
Also, it is possible to show updated stock level in the main ProductTable? How this can be realised?
I just started learning Access for couple months, and only know very little about Macro and VBA. If any programming is needed, please kindly post the code as well.
Thank you for your help in advance.