Thanks FishVal!
That was the tidbit I needed: changing from private to public. those headings are automatic and I forgot to even think about it. But of course.

And NeoPa, yes, your suggestion is the more proper way to handle, and would be how I would do it if I knew about this at the time the original report was created and that submission form was designed. But I personally don't want to spend the time re-writing the code...

Hi.
I have two forms. The first, designed some time ago, is just a report request form and has a combo box to select a workorder, click "Run Report" (cmdRunReport), and the user gets a status report on this workorder. There's a lot of code in the cmdRunReport module.

Now I have a new form for a different use, but it also happens to have the same workorder selection field. The head user just said, golly, can we get...

Never mind everyone. I solved it myself. This is the ApplyFilter event:

Private Sub Form_ApplyFilte r(Cancel As Integer, ApplyType As Integer)
If ApplyType = acShowAllRecord s Then
If Me.SelectWorkor der > "" Then
Me.Filter = "WONumber = '" & Me.SelectWorkor der & "'"
Cancel = True
End If
End If
End...

Hi All,
Just joined this community, hope someone can help. I have a form (just a main form, no sub form), and the user selects a work order in a combo box at the top, and the form filters on this value. the user may further filter other fields by clicking in the field then using the Filter By Selection icon along the top, and when they're done, they click the Show All Records icon. I see that the ApplyFilter event fires on this, and the...