ListData refresh onClick

You could create a function, something like:

Private Function fnRequeryLists

    Call Me.List164.Requery
    Call Me.listExtension.Requery
    Call Me.List169.Requery

End Function

Select allOpen in new window

Then select all of the controls you want to do this from, open the Properties dialog and go to the Events tab, then type:

= fnRequeryLists()

into the GotFocus event.

HOWEVER, I cannot for the life of me figure out why you would want to requery these lists in the GotFocus of anything.  Assuming that those lists have RowSource values which refer to controls on the form, you would normally do this in the AfterUpdate event of the controls which would affect the values displayed in those lists.

FURTHERMORE, if those lists are cascading, they depend on the value in another one of the lists, then doing this would requery those lists and the cascading aspect would fail.

It might be better if you could take a screen shot of your form in design view and explain what you are trying to accomplish.

HTH
Dale

Sir. Thanks for the reply. Will try Function.
Meanwhile, would like to clarify :

1. Screen shot is attached
2. MY purpose : On clicking a Purchase Record in datasheet,   i can take a glance its Sale, its lifting qty etc.
3. This form is not used for Data Entry , but i am using it for muliple querry / calling of records only.

Best Regards,
Kamlesh Jain
2017-04-27.png

Wow .. Wow ... Thank you Sir ... :) working Perfectly ..

glad I could help