Searching the subform of a subform.

[MatthewGrace]

I have a list of Skids to be shipped in Datasheet view. Each skid has orders on it, displayed in the Expanded Subdatasheet. It looks kinda gawky at the moment, but I'm wondering if there's a simple way to search for stuff in the Subdatasheet.



I came up with something like:

Skids_subform.Form.Filter = "[CustFK] = " & cboSearchCompany.Value
Skids_subform.Form.FilterOn = True
Skids_subform.Form.SkidContents_subform.Form.Filter = "[Jobname] = '" & txtSearchJobname.Value & "'"
Skids_subform.Form.SkidContents_subform.Form.FilterOn = True

It works... But with a weird hit-or-miss style. Sometimes it works, sometimes it doesn't. If the first two lines of code aren't run, it will never work. I can't even grab the Caption property from the sub of the sub.

I can't help but wonder if there's a more standard way. Any thoughts appreciated.

[orange]

You have shown us HOW you have done something --form subform subform and sub datasheets. But WHAT is it you're trying to accomplish
in plain English -- business terms no Access, no database jargon?

[MatthewGrace]

I'd like to know what kind of code is appropriate for filtering the Subdatasheet directly. I cannot reference it's .filter and .filteron properties, or any property for that matter, without generating an error (see my 4-line code example).