notconfident
Programmer
I have a MainForm with a RecordSource of Current_Marshal.
In that there is a SubForm with a RecordSource of WWtable
They are linked with Ref_No.
On the SubForm there are 5 Controls, 3 come direct from the WWtable and fill fine of course,
these are 2 comboBoxes and a TextBox.The other 2 are TextBoxes but are slow to fill.
The SubForm has about 14 records.
When I move from one record to another on the MainForm all the 3 good controls fill for all records
and in the first record the other 2 problem controls fill.
Then there is a pause of a couple of seconds then the other SubForm records fill.
These 2 problem controls are populated from their ControlSource. here is one :-
=DLookUp("[DescriptionForCard]",
"tblSession" & DLookUp("[EventYear]","MiscTable","[MiscTableID] = 1"),
"[SessionID] = " & [Forms]![Normal View Form]![SubWW]![SessionID])
I had a similar slow problem on the MainForm and put the DLookup in vba as in the MainForm OnCurrent Event.
This was quicker !!
I cant get the same trick to work in the SubForm OnCurrent event.
This is slower in practice as it is over a network. My tests are just local.
Any Ideas??
Thanks
In that there is a SubForm with a RecordSource of WWtable
They are linked with Ref_No.
On the SubForm there are 5 Controls, 3 come direct from the WWtable and fill fine of course,
these are 2 comboBoxes and a TextBox.The other 2 are TextBoxes but are slow to fill.
The SubForm has about 14 records.
When I move from one record to another on the MainForm all the 3 good controls fill for all records
and in the first record the other 2 problem controls fill.
Then there is a pause of a couple of seconds then the other SubForm records fill.
These 2 problem controls are populated from their ControlSource. here is one :-
=DLookUp("[DescriptionForCard]",
"tblSession" & DLookUp("[EventYear]","MiscTable","[MiscTableID] = 1"),
"[SessionID] = " & [Forms]![Normal View Form]![SubWW]![SessionID])
I had a similar slow problem on the MainForm and put the DLookup in vba as in the MainForm OnCurrent Event.
This was quicker !!
I cant get the same trick to work in the SubForm OnCurrent event.
This is slower in practice as it is over a network. My tests are just local.
Any Ideas??
Thanks