Relationship Between Two Subforms

[eww]

I've got a Project Information form with two subforms in it. One is a Submittal form where employees will enter the submittal date, weight amount, and description of what they detailed. The other subform is a Segments form, in which the employees are to enter segments of the entire project to detail (like categories).



I have a "segments" combo box in the submittal subform that ideally I would like for the user to be able to pull down and select which segment (category) they are entering the submittal under. Both of these subforms I have related to the Project Information form through the Job Number, so for each record the related records in the subforms (to that job number) show up.

My problem is when I go to pull down to select a segment, I get all the segments entered in the entire Segments table. I'm confused about how to relate these to get just the segments for that job number to show up in the combo box drop down.

[NTC]

that combobox has a record source. go to its properties, and select the ellipse .... and open up that record source in query design mode....then modify it to include criteria that will limit it to just record set you want. Probably this will be via a reference to a value elsewhere on your form i.e. Forms!FormName.JobNumberTextBox

hope this helps.

[eww]

The criteria! That's what I needed, thanks for the help NTC.