FuzMic
DataBase Tinker
- Local time
- , 07:22
- Joined
- Sep 13, 2006
- Messages
- 739
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?
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?