How to check for Open Form with vba

J

John Michael

How do you check for an open form with vba.
I'm trying to requery a subform with the below state ment and it only works
if the form is open.
Forms![Open Transactions]!ctrlOpenTransactionsSubform.Requery

Thanks
John Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Unremovable horizontal scroll bar on subform 1
How to open multiple instances of Word 365? 5
filtering a form based on the values of a subform 0
Error outlook.com 0xc0000005 trying to open custom controls 0
Slideshow with black border around it 0
How to use subfroms based on VBA. 0

Top