Originally Posted by
Bob Fitz
If you are saying that all the sub forms reference a combo box on the main form to restrict the records in the subform, then keep in mind that the subforms actually open before the main form opens. Perhaps set the RecordSource properties of the sub form once the main form has opened.
While that is true for subforms, I'm pretty sure that it's not the same for subreports, which is what the OP is using.
Ideally, you shouldn't be asked to input the value even once. I take it that the field containing the value is not on the main report, or the value isn't making it there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.