G
Guest
I can't articulate this exactly how I want to so I going to use an example in my database. Hopefully it will not confuse
I have 2 forms the first form contains details in regard to nurseries the second a subform contains details as to nursery inspection. When you do a nursery inspection you actually inspect a "seed lot". The "seed lot" field in the subform is a combo box, it gets details from another table which contains details such as the seed lot number and the nursery it is at etc..
So firstly I scroll through all my nurseries, the sub form linked on the nursery then displays all the inspections. To do a new inspection you choose a "seed lot" in the subform. I would like my "seed lot" combox not to show all seed lots just those that match the nursery. Can I filter the combo box based on the value in another field. If nursery A is selected only show in the combo box seed lots also at nursery A
Wow that confused me a little, hope someone can help. I will think about rewording it a little better in the mean time
Cheers Trevor.
I have 2 forms the first form contains details in regard to nurseries the second a subform contains details as to nursery inspection. When you do a nursery inspection you actually inspect a "seed lot". The "seed lot" field in the subform is a combo box, it gets details from another table which contains details such as the seed lot number and the nursery it is at etc..
So firstly I scroll through all my nurseries, the sub form linked on the nursery then displays all the inspections. To do a new inspection you choose a "seed lot" in the subform. I would like my "seed lot" combox not to show all seed lots just those that match the nursery. Can I filter the combo box based on the value in another field. If nursery A is selected only show in the combo box seed lots also at nursery A
Wow that confused me a little, hope someone can help. I will think about rewording it a little better in the mean time
Cheers Trevor.