chuckcoleman
Registered User.
- Local time
- Yesterday, 20:04
- Joined
- Aug 20, 2010
- Messages
- 363
Hi, I've done some research on this but so far can't find something that works. I have two subforms on a main form; subform1 and subform2. There are two combo boxes on subform1. In the after update event of combo box1 it requery's subform2. In the after update event of combo box 2 it also requery's subform2. Subform2 has two fields in both the Link Master property and the Link Child property. This all works fine when there are values in both combo boxes. Combo box2 when clicked on allows the user to pick a manufacturing plant number and then in subform2 the materials are shown. What I'm trying to do is if the user doesn't pick an item in the combo box2, (it's null), then I want to show all of the materials from all plants.
I'm looking for help on the code to make this happen.
Thanks,
Chuck
I'm looking for help on the code to make this happen.
Thanks,
Chuck