List box on continuos form ,bound ,unbound?

E

eb1mom

Working on a message and reply database. I have a message
table and a reply table. One message to many replys. I have
a continuos form (message table) with a list box (reply
table). I am trying to show each message with all replys to
that message. I tried creating a query based on message
number in form and using that as source for list box
but,then it shows same replys to all messages. I tried many
other ways and can't seem to work out what I am doing
wrong. Any suggestions would be appreciated. thank-you
 
A

Arvin Meyer

You cannot use an unbound listbox on a subform and get bound results. Trying
to do so will get you the same result, as you see has happened. What you
might do is to use 2 subforms on a main form and sync them similar to the
way that the Orders and Order Details sunforms are on the Customer form in
the Northwind sample database that came with Access..

You do not need to bind the main form to data like Customers, but the second
subform should be bound to a textbox on the main form that mirrors the ID
value from the first subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top