Filter Combo box

message from =?Utf-8?B?VHJldm9y?= on 2 Jun 2004
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.

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.
 
Ken Snell replied to =?Utf-8?B?VHJldm9y?= on 2 Jun 2004
http://www.mvps.org/access/forms/frm0028.htm
 

Archived message: Filter Combo box (Microsoft Access)