Requery macro dont work

[Lubosh97]

Hi, i need to requery Query from Form where i have button. Button is based on onclick macro. After click it still calling error 2950. I configured trusted locations as advice MS support.

Have you any ideas how to fix it ? Thank you

[rpeare]

Does your button click physically open a query? if so you'll have to close the query first then reopen it.
If you're requerying a list box or subform or form contents that's a different matter, what does your code look like? or macro I guess. Most advanced users do not use macros because they are too limiting but we may be able to spot the problem and offer a different solution.

[ranman256]

You requery the object on the form. Obj.requery. And make sure the object has a recordsource.