continous refreshing

[xxyy]

Hi!

I'd like to ask for your help in the following issue:

I wanted to refresh the filtering of my combo-list on a subform according to the change of a field on the main form.

With this

Private Sub supplierID_AfterUpdate()
Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery
End Sub

it succeeded. But when I turn a page on the main form (to see records registrated in the past), the combo-list on the subform doesn't change (because Access doesn't get any after-update info - I guess).

But I'd like to use a solution that always watches the actual value of the main form displayed on the screen and so it changes the filtered list of the sub-form - combo-list according to it.

Please help if you have a good idea/solution to it.
(take care I'm beginner at Visual Basic)

Thanks

xxyyy

 

[xxyy]

FYI

In the meantime, I was working on the issue.

A very simple solution seems to me to bind the requery not to the updating of the field on the main form, but to the sub-form - combo-list itself.

Private Sub KombináltLista4_Enter()
Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery
End Sub

When entering the combo-list (on the subform) will run the filter-query to display only the relevant items.

Considering these method the after-update code

(Private Sub supplierID_AfterUpdate()
Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery
End Sub)

seems uneccessary.

best regards

xxyyy