Need Report to display additional information based on user input from form.

[parkerjallen]

On the form from which I'm making a report, the user puts in a series of single characters in their individual boxes, which correspond to a different table. The string of characters makes up the part number.

The table that stores test results is called TestResults.

The form TestResults asks the user for "pCon1" which is a combo box limited to letters from table idConnector. "pCon2" also does the same thing.

"pMode" from table idMode
"pCable" from table idCable

and so on.

In each "idTable," There is a second column with description information. Based on what the user puts into the form, I need the report that will be drawn up and printed from that to display each "description" and it will read sort of like a description based on the entire item from the part number.

What is the best way to go about this?

 

[parkerjallen]

I've figured out how to do what I want, but now how do I make it so a particular field is not required for it to show up on the query?