Query in a listbox

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?
 
K

KARL DEWEY

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.
 
Top