Jackie
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.)
> How do I set the value of a list box control on a form base on the value
> from
> a combo box on the same form?
>
> Thanks