Query in a listbox

  • Thread starter Thread starter albertoocdc
  • Start date Start date
A

albertoocdc

Hi.

I have a form with a query. This query only shows one field (idthing)

I have in my database an N..N table (things <-> otherThings)
For one thing I could select N otherThings.

OK. I want to include in my form two listboxes. One of them populated
with the otherThings reelated to idthing, and the other one with the
rest of the otherThings. Then I´ll put some buttons for passing
otherThings from one ListBox to the other.

I don´t know how to do this. I suppose I´ll have to do a Query that
selects all the otherThings related to things with the idThing =
idthing that shows in the form, but I don´t how to make that.

Any help?
 
Use two subfoms, each with their own criteria. You can not move like you are
suggesting but you can change the data that gives different query results.
 
Back
Top