how access listbox recordset for another query??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a listbox. When the listbox has been populated the user can press a command button to display another form. This new form is based on a query that needs access to the recordset in the previous forms list box, e.g
SELECT ID, x, y, z from table where ID in (SELECT DISTINCT ID from listbox-recordset)

How would I do this, do I use recordsetclone somehow ?
 
Try The Access Web article:

Use Multi-Select List boxes as query parameters

--
HTH
Van T. Dinh
MVP (Access)



David said:
I have a form with a listbox. When the listbox has been populated the user
Click to expand...
can press a command button to display another form. This new form is based
on a query that needs access to the recordset in the previous forms list
box, e.g.
 
Back
Top