Search results

Got it at last Just in case anyone else runs up against this. To remove a subform filter without removing any filter that has been applied to the main form, reset the Recordsource property of the subform to it's original value. In the code frag below, str_SF_SQL is the SQL statement that was...

Still no luck I've tried that thanks, but it still don't work. It seems that any time you take a filter off a subform, the filter on the main form is removed too. Oh well.

Dmax Maybe I've got the wrong end of the stick here, but it could be that MyDmax = Nz(DMax("[WLngNo]", "testWLog", "Preparedby='" & Environ("Username") & "'"), 0) + 1 should be replaced by MyDmax = Nz(DMax("[WLngNo]", "testWLog"), 0) + 1 i.e. take out "Preparedby='" &...

When a filter is removed from a subform, any filter that had been applied to the main form is removed too. This a nuisance. I've got a work around but it's ugly. Here's what happens. Right clicking the subform calls up a custom menu that has a custom Remove Filter option. This in turn calls...

subform filter trouble You could try changing the RecordSource for the subform. Something like this: Private Sub find_Click() On Error Resume Next Dim str_SQL As String, dbl_Date as double 'If the entry in the date box isn't a date, there nothing to do 'though you could...