how to manage two combo boxes to requery subform

[Monkeyisland]

Hi,
I have 2 forms on my DB - one to allow user to create a new record. The second to select and modify the record. Its for a manufacturing environment so user enter a work order number (WO).

In the second form they enter the WO (scan WO from paperwork into ComboBox) and the AfterUpdate event queries the table for the WO and refreshed the subform with the data.

I have now modified so the user enters the step on the WO e.g. Step 10 or 20 or 30 so I now have multiple entries for the WO in the table.

How can I design my 2nd form to refresh the subform ? Do I need a second ComboBox for the user to scan in the step and how do I structure my query in the AfterUpdate ? Or is that the way to go ?

New to this so appreciate any help / advice you can offer.

Thanks, M.

[ranman256]

you shouldnt use 2 forms. 1 form can do data entry and edits. This way you dont get this unsync'd list.
but
if you want to continue using 2 forms, you can refresh 1 form from another just by using the full path....

in fMyForm1:
forms!fMyForm2!subform.requery

[Monkeyisland]

OK - I can see the advantage of using one form - I can have a button to create a new record. But if an operator enters 10 new records and needs to edit record #3 how can I prompt for WO and Step ? Combobox ?
thanks, M

you shouldnt use 2 forms. 1 form can do data entry and edits. This way you dont get this unsync'd list.
but
if you want to continue using 2 forms, you can refresh 1 form from another just by using the full path....

in fMyForm1:
forms!fMyForm2!subform.requery

[aytee111]

Not sure how the data looks for your work order, but usually in these scenarios there is a combobox to select a work order and a continuous subform showing all the records belonging to that work order. The user can then edit whichever record they wish.