FuzMic
DataBase Tinker
- Local time
- Today, 22:34
- Joined
- Sep 13, 2006
- Messages
- 719
Hi guys
This is really puzzling for my little brain.
I have a FormM with than one sub forms. I use one of this subform eg SwForm to filter or change the recordsource on TargetSubForm eg TargetSubForm.Filter = "[fid] = 'x'" whenever SwForm goes currentEvent on a record ie arriving on another record X values changes to another.
The other way i tried was on currentEvt on records in SwForm will cause the TargetSubForm.recordsource to be assigned to something else"
I works ok the first time i use this FormM; filter works or recordsource changes as planned.
But if i leave this FormM and reenter 2nd time, both filter and recordsource don't work.
Really puzzling and spend hours still no clue WHY? Help!!
This is really puzzling for my little brain.
I have a FormM with than one sub forms. I use one of this subform eg SwForm to filter or change the recordsource on TargetSubForm eg TargetSubForm.Filter = "[fid] = 'x'" whenever SwForm goes currentEvent on a record ie arriving on another record X values changes to another.
The other way i tried was on currentEvt on records in SwForm will cause the TargetSubForm.recordsource to be assigned to something else"
I works ok the first time i use this FormM; filter works or recordsource changes as planned.
But if i leave this FormM and reenter 2nd time, both filter and recordsource don't work.
Really puzzling and spend hours still no clue WHY? Help!!