displaying certain records in a list box

[Hiten]

Hi guys
I have a form, that is adding info to another table, a 1 to many relationship. When i select a contract from my combo box, i want to only view that contract numbers history in the list box below, how do i do that????????????????/

Thanks guys

H

 

[Rich]

Use a query/sql as the record source for the list box, set the criteria for some field to that of your combo box, requery the list box after updating the combo box.
HTH

 

[Hiten]

Sorry to sound a bit dumb but could you explain in more detail, i still couldnt get it to work?

thanks