I have a mainform with a listbox. When the listbox is selected, the mainform is set to the record selected.
The mainform has a subform with a listbox on it. Its rowsource is in vb SQL code which fills the listbox with related data to the mainform.
I originally put the subforms list query in a command button which also opened the subform, however there was an unwanted delay in the subform being visible whilst the list was being filled.
I then moved the query to the oncurrent event of the subform. This worked faster, however the list being clicked on the mainform momentarily goes blank while the subform list query is being run. Has anyone had this or can suggest any cure.
Many thanks
The mainform has a subform with a listbox on it. Its rowsource is in vb SQL code which fills the listbox with related data to the mainform.
I originally put the subforms list query in a command button which also opened the subform, however there was an unwanted delay in the subform being visible whilst the list was being filled.
I then moved the query to the oncurrent event of the subform. This worked faster, however the list being clicked on the mainform momentarily goes blank while the subform list query is being run. Has anyone had this or can suggest any cure.
Many thanks
