Combobox: Get value from another query AND find record on form

[soco3594]

Hi guys,



I'm trying to add multiple comboboxes to a form so that I can filter my search results and then display a record on the form based on the last selection. E.g. I have tables for Equipment, Sub-Equipment, and Repair Scope. I want to be able to select from comboboxes on the form as follows:

Combobox 1: Select Equipment from list
Combobox 2: Select Sub-Equipment from list based on Equipment selected in Combobox
Combobox 3: Select Repair Scope from list based on Sub-Equipment selected in Combobox 2 AND show that record on the form

I can do steps 1 and 2 fine, just not sure how to achieve step 3.

Thanks in advance

[alansidman]

Here is a tutorial for cascading combo boxes.

http://www.fontstuff.com/access/acctut10.htm

[CJ_London]

you can try something like this in the combobox3 afterupdate event

me.filter="ScopeID = " & combobox3
me.filteron=true

[soco3594]

Thanks guys.

I'm fine with cascading comboboxes, it was the after update bit I was after. Will give it a go