I have a report in MS Access I select the textbox option in put this into the control source:
The SP is in ssms so:
In the VBA
Strsqr() -- I know this is not correct please correct
also in VBA don't I need some parameters? like pmrcat1? so I will need help with that as well.
I know that the user is going to select category (Cat1)
The SP name\pamr is stored in a Access Table(s)
so in ssms:
From Tables involved TI.
Where TI.Cat1 = @Cat1
I think I am correct but may need more help?
Please help and thanks