My RecordSource in OpenEvent don't fire

[FuzMic]

Hi guys

I have a form with view as 'Pivot Table' and want it to be use for 2 instances with different recordsource.

I normally can do this in all my other forms by changing the recordsource at the Open Event, be not with this form.

I tried the following options without any success:
1 Change back to Single Form View
2 Place the change of Recordsource codes at the Load and Activate Event
3 execute me.requery after the recordsource assignment.

For this form, i must place the RecordSource within the form itself, else changes in the Event gives a blank form.

What's is the diagnosis?

 

[FuzMic]

Thanks Bro .. learning as always
I mean at the form properties.

 

[FuzMic]

Gizmo
I tried with acnormal in Open form then what you suggest outside the Open Event work

If I use acPivotTable or set DefaultView to Pivot table, then same outcome .. blank