I am trying to build a query will pull up data based on the field of a form. The problem is I would like to do this without stating the exact form. We have 9 different form that are nearly identical. All the forms will have a button that will have a report based on that query.
I tried: WHERE ((([Memo List Table].MemoNumber)=[Me].[MemoNumber]));
I was hoping that would simply look for the form that the button was on. Is there away to state something like [CurrentForm].[MemoNumber]
I hope I made enough sense! Thanks for the help! Happy Friday