ListBox based on current recordset of other form

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

A2K

I want my lstFileList (on a custom dialog) to list of current records as
shown on the calling form. The calling form has a subform that diplays
results from a combo box selection. So I have a cmd button that opens the
custom dialog with the list box. I want the listbox to again display the
same results as the subform.

Brad H.
 
You need to set the Row Source of the listbox to the same query as the
subform filtered by the selection in the combo box (modify the WHERE clause
of the query). If this is already what you're doing to fill the subform
(i.e. not using Master/Child Link Fields), you could just use the same SQL.
 
Back
Top