Using Combo Boxes to Complete a Query Question
What I have set up is a group of three combo boxes in a form. I also have a command button that opens a report based on a query. This query asks for three inputs to complete the report. What I want to do is have the answers to those questions filled in from the current record that is being looked at.
So a person is looking at a record and it says the location of the sample is Dewar: A, Can: 2, Cane: 31. Then when you open the report it asks for these three bits of information and I want them to be automatically filled in. Is this possible. Thanks
|