Form Update worked then...

[Kenln]

I have a form based on a query that used this subroutine

Public Function fCboSearch(vCboSearch As Variant)
   If IsNull(vCboSearch) Or vCboSearch = "" Or vCboSearch = "<Select All>" Then
        fCboSearch = "*"
    Else
        fCboSearch = vCboSearch
    End If

End Function

When a user changes one of several combo boxes I execute this

Me.Requery

Everything has been fine until I changed linked tables to Pass-Though Queries. Now it WON'T update.

Oddly enough the Combo boxes do, but not the form's recordset.

So I select a combo box that filters the form from 1000 records to 3. The Combo box now shows three records and the from still shows 1000???

Help??? How do I get the form to upate?

 

[Kenln]

I changed to a Pass-Through queries (actually Table Valued Functions) to replace direct Access to Tables and because I wanted to write one function that could accept variables.

I actually do create queries on the fly, BTW.

Essentially I was/am doing exactly what you suggested except I changed from a linked table to a passthrough query and I was wondering why the form stopped updating when the combo boxes update.

Any thoughts on how to get the form to update?

 

[Kenln]

PS, what I replace wasn't actually linked tables but was linked views which appears as tables. I'm still trying to figure out how to link to a function as a table. That would be my goal.