Cantthinkofone
Registered User.
- Local time
- Yesterday, 22:29
- Joined
- May 2, 2018
- Messages
- 19
I have a 2016 access db with a form which contains a subform. The parent form has a combobox to select which staff person I want to query/filter the data and show in the subform. This works great.
In the subform, I have an 'on dbl click' event on the order number to open an 'Order Details' form based on the order number I double clicked. This is the hiccup, when I use an OpenForm Macro with Where "[OrderNumber] =" & [OrderNumber], instead of passing the value, I get a parameter prompt message box to re-enter the order number I just clicked.
When I tried the same OpenForm Macro, removing the Where and replace with a Filter Name qry Order Details to filter on the chosen order number, I again get the parameter message box prompting to enter the order number.
I'm sure there is an easy, logical solution that I can't wrap my head around.
Thanks for reading my novella and any assistance is appreciated.
In the subform, I have an 'on dbl click' event on the order number to open an 'Order Details' form based on the order number I double clicked. This is the hiccup, when I use an OpenForm Macro with Where "[OrderNumber] =" & [OrderNumber], instead of passing the value, I get a parameter prompt message box to re-enter the order number I just clicked.
When I tried the same OpenForm Macro, removing the Where and replace with a Filter Name qry Order Details to filter on the chosen order number, I again get the parameter message box prompting to enter the order number.
I'm sure there is an easy, logical solution that I can't wrap my head around.
Thanks for reading my novella and any assistance is appreciated.