More of an Access 2000 question

I have a form in Access 2000 with a bunch of normal text box fields. One of the fields is a list box, bound to another table of publishers. What I would like to do is allow the user to change this list box, and update the rest of the fields based on this list box.

For example, in the list box I have 4 publishers. When the user changes this list box, the rest of the fields only show records that are from this publisher. Any help is appreciated.

My advice would be to take the value of the combo box and write a select statement that looks up that value in the table that you want the additional data from. Once you've got the data (preferably via ADO) you can place it in the appropriate controls.

There may be an easier way to bind the controls but I'm not a big fan of binding.