Struggling with txtBox and Subform....

[GodofSmallThings]

Hello,

I have a form that contains a txtbox and a subform.

The subform displays all available training titles.
It contains 3 fields. DocNumber, Name, and Select.

The Select field is a Checkbox (yes/no)

I would like the subform; in addition to showing all
available titles; mark selected records based on the
txtbox on my form. So for example.

When Administration is displayed in the txtbox.

The titles associated with that department are
highlighted with a check mark in the subform.

I can do this manually in a 3 step cumbersome process.
It pops up with all those warning messages - Updating
5 records. blah...blah...

I can automate it with a macro. But I want to learn
how to process it through ADODB.

My database contains 3 tables. tblDept, tblRequirement,
and tblTraining

tblRequirement joins tblDept and tblTraining.

Thanks for any ideas you provide.


GodofSmallThings