How do you get List Box to select & show records in a form?

[tjosam]

I want to design a form that displays a sub form (for editing and adding records). I want to select a project number (next to company name) from a list box. The source for the list box is a query that shows project number and company name. I want the selected project number from the list box to display only the records that match the selected project number in the sub form. There can be many records for each project. I therefore want only one project number (company name) to show in the list box.

I created a form using form and list box wizards, but when I toggle between (2) different project numbers in the list box, MS Access randomly overwrites one of the project number fields in the sub form with the value of the other project number, thus corrupting the underlying table.

Is there a clean and reliable way to create a form that displays records that match a field in a list box?

Thanks,
Tom