Combo box as record navigation?

[bozrdang]

I need to create a form that will record the molds that can produce a specific part. I would like this to be navigated using a combo box that the user would use to select a part and then have a subform that shows all molds that can be used to produce that part. Something similar to a normal form and subform except I want to use the combo box instead of the navigation buttons to select records in the main form.

I have been able to use an unbound main form and combo box and a subform based on a query (qryPartMolds) to show corresponding molds, but I can't add a new record (mold) in the subform because the combo box is not passing it's value to the foreign key of the subform (like a traditional form/subform does). The PartID in the subform isn't assuming the value of PartID in the main form (again, like a traditional form/subform).

How can I accomplish this? Any help would be appreciated.

 

[WayneRyan]

boz,

If you don't use the Master/Child links then the
best way to do this is to have the value for the
child's default value:

=Forms![YourMainForm]![YourCombo]

You don't have to make it visible, and if you do
don't let them edit it.

Wayne

 

[bozrdang]

Thanls a lot! That was really easy. I am continually amazed how easy it is to overcomplicate things in Access. I do it constantly only to find out that the solution is sometimes quite simple. Thanks again!