I have a form that I use to enter data. On this form I have some command buttons that query other tables via a parameter query eg sales by customer number, contact notes by customer number etc. These tables are updated either from this form, or other forms.
What I would like to be able to do is if I am entering data for customer eg 895 is click on the command button for notes on this customer and have the customer number "flow" through to it. I can use a sub form and view the raw data , but prefer a report based on the parameter query.
I am trying to avoid having to key in the customer number and hence avoid my tendency to miskey the number!
Any ideas would be gratefully received.