I have a small job, I need a Macro placed in a report item that opens a form to the corresponding product ID.
I’ve already made the form and the report, but I can’t seem to construct the Macro to open the form to the correct record, it just opens to record #1.
I’ve attached the Access database for you to look at.
The Report is titled Reorder Watch and it links to the Form titled Inventory Details & Order, both can be found in the Inventory section.
The link on the Report that should open the Form is item / SKU.
Note: There is a Form named Inventory Stock Levels in the Inventory section which does exactly what I need the above task to accomplish if you need a reference, the reason I don’t use it is because I need to add a query field to it, but can’t get the extra field items in the Add Additional Fields dialog in design view.
My maximum budget is $40 USD
Thank you for your interest!