Hello,
I have a subform that displays selected records according to the relationship with the main form. On the subform I have a listbox to navigate through the records (navigation buttons are not visible). To populate the listbox I currently use a OnCurrent event of the subform to query something like:" Select UniqueID From TableX Where ProjectID = '" & Me.ProjectID & "';". I.e. I select the records that the main form as already selected to have the subform displaying.
I am wondering if there is a clever way to do this and avoid to create a query for each record that is displayed on the main form.
Thanks in advance,
Mauro
I have a subform that displays selected records according to the relationship with the main form. On the subform I have a listbox to navigate through the records (navigation buttons are not visible). To populate the listbox I currently use a OnCurrent event of the subform to query something like:" Select UniqueID From TableX Where ProjectID = '" & Me.ProjectID & "';". I.e. I select the records that the main form as already selected to have the subform displaying.
I am wondering if there is a clever way to do this and avoid to create a query for each record that is displayed on the main form.
Thanks in advance,
Mauro
