Need to change the ControlSource

[regava]

I have this report based on a query. One of the fields in the query was changed. I wonder if there is a way to change the property ControlSource in GroupLevel0 in the report? I have tried the following code in the Open event procedure: Me.GroupLevel(0).ControlSource = ALJName and did not work, I got error 2427 - You entered an expression that has no value. Any help is appreciated

 

[CosmoKramer]

What is ALJName? If it's a control on a form you have to explicitly define it:

for example - [tt]Forms!MyForm!ALJName[/tt]

I'm CosmoKramer, and I approve this message.

 

[regava]

ALJName is one of the fields in the query

 

[regava]

I found the solution:
Me.GroupLevel(0).ControlSource = "ALJName"
Thank you.