You would probably have more luck (i.e., more "eyes" on your post) if you
re-posted to a forms-related newsgroup. This one (tablesdbdesign) focuses
on tables and db design.
Regards
Jeff Boyce
Microsoft Office/Access MVP
(hint: in the query that underlies the listbox, include a selection
criterion that points to the combobox.)