Create subform filter and then check associated items

[spudracer]

I'm trying to write the code for this, but VBA is just not something I'm 100% familiar with yet.

I want to create a filter that asks the user for input. I want the results restricted to just one column (so it won't filter down to anything containing the user's search string).

Once it has filtered down to the user-set criteria, I then want it to check the checkboxes associated with all of the filtered items.

Easy, right?

 

[spudracer]

Just to clarify, this is what I have so far.

Me.RecordSource = "SELECT * FROM qryInventoryActive"
 
Dim strMsg As String
Dim strInput As String
 
strMsg = "Which Case?"
strInput = InputBox(Prompt:=strMsg)

DoCmd.ApplyFilter , [CASE] = strInput

This doesn't return an error, but it also doesn't filter.