Hello Everyone,

I am trying to see if I create a database without any Macros & any defined queries (shown in the query tab). So far I have been able to succeed except that I have a few pivots based upon some of the queries.

What I am seeing & asking how to do is, is there a way to define the query in code when the form opens. so the pivot references the code instead of the actual query.

Thanks!!

Chris,

The Open event is better than the Load event.

Something like this, if I understand you correctly...

Me.RecordSource = "SELECT ... "