I have a report that prints out all sales worksheets.
I would like it to just print out the one a user chooses.
I'm thinking the best way to do this is to have a concatenated combo box on some form which shows the worksheets (with the customer name, model and serial number), and somehow get the sql query to pull from the form. (WHERE [Machine Detail].DetailID = Forms![Machine Worksheet].cbDetailID
I have nooooooooo idea how to do this.
Ideally, I would be able to print one instance of the report from the worksheet form (in my case, I imagine it would be something like WHERE [Machine Detail].DetailID = Forms![Machine Worksheet].txtDetailID).