I have a report with twenty or so textboxes with labels that I'm dynamically setting the controlsource properties and the controlsource to in an effort to hide fields that do not apply to that particular record. this is done by opening a sub-report in design view and hidden, modify the recordsources, then opening the report. The problem is that this locks any other user out of the database. I have found that this cannot be done when the report is opening so I need assistance with another means of achieving this goal. Thanks.