Hi
I have a form which has a button which opens an additional report using a text box on the form as criteria. This works fine when the form is opened by itself but when I open from within a navigation form it doesn't work.
I could change the WHERE clause to lookup through the navigation form but I want the WHERE clause to work when the form is opened by itself or from within a navigation form.
I have 3 forms as follows
frmNavigation1
frmNavigation2
frmProduct - Standalone form or as a sub form to the navigation forms.
I've used the macro builder on the button to open the report and have used the WHERE clause...
I want create the WHERE clause in a way that allows the report to open correctly whichever form is opened up. How do I code this?Code:[product]=[Forms]![frmProduct]![product]
Thanks