Search continuous forms

[LReber]

Hi - been looking at A. Kallal's examples and have half a solution. I have

tblCategory pk CatID
tblSubcategory pkSubcatID
tblOfficialName pkNameID

I'm able to set up a form / subform that shows the choices available after
picking a category, then a subcategory. I'd like to be able to type in a
name, like mill, and have a list of names show up, and by scrolling thru'
those names, see the subcat & cat choices. A mill can be a coffee grinder, a
building, a machine, etc.

AK's examples are inspiring but I'm novice enough that I have no idea where
to begin.

Thanks - Lisa