Help with dropbox + subform

[krouchchocolate]

Hello,

I am trying to create a form that will include a dropbox + a subform. For my project it consists of a single serial number, but that serial number may contain a lot of part number with a date differentiating each part number.

In the dropbox section, I want to be able to click any serial number I am looking for. For the subform, I want it to display all that part number and each date that correlates to that one serial number.



However, whenever I drop the box down and choose any serial number, the part number does not update along with it.
For Example:
Serial Number: 7026707 -->PN1:X1523 1/1/2011, PN2:X1535 1/3/2011, PN3:X5555 3/3/2011


Has anyone else ever ran into this problem? It is making me frustrated.

---

[amrut]

Ensure that Sub-form returns all records for Serial number and Part numbers when the form opens.
Use following code in the after update event of the combo box having your serial numbers.

With Me.YourSubFormControl.Form ' YourSubFormControl is the name of SubForm control used on the main form
.Filter = "[YourFieldName] Like """ & Me.YourComboBoxName & "*" & """" 'YourFieldName is the name of serial number field.
.FilterOn = True
End With