Requring query on the fly

[jaryszek]

Hi,

i am using code to update rows within query:

With rsDao    If Not (rsDao.BOF And rsDao.EOF) Then
        rsDao.MoveFirst
    End If
    Do Until rsDao.EOF
       ' rsDao.Fields(12).RecordsetType = 1
        rsDao.Edit
        !Status_name_ID_FK = 3
        !Status_date = Now()
        rsDao.Update
        rsDao.MoveNext
    Loop
    
    Me.Requery
    Call KoszZusFaktur
    'Me.Refresh



End With

This is working on multisearch textboxes on split form:



Now i am filtering statuses using word: "Zakończono"
I have 2 statuses and now my code above is running.

I am changing via code these statuses from "Zakończono" to "Wyeksportowano".
It is working like a charm.

Problem is to see this.
When user is changing statuses I have to requery query and my filter is not actual, so here is nothing filtered (all statuses "Zakończono" were changes to "Wyeksportowano").
How can i show user his changes?

Output:




Any ideas?
Best Wishes,
Jacek

[ranman256]

There is no need to use code. This is very slow.
Create an update query to do it all at once.

[jaryszek]

thank you ranman256!

Do you think that if i write:

UPDATEMyTable
SETStatus_name_Id_FK= 3

it will change only my filtered values (using multisearch textboxes) or it will change my whole query?

Best Wishes,
Jacek

[jaryszek]

Ok i have checked it and it is owrking only for filtered values !!!
wow,

thank you!

Best wishes,
Jacek