Solved: Troubleshooting VBA Form Reference

Okay, interesting new complication today.

I created a form called FmSearchWorkProgress. I have a cmd button with an on-click procedure to open FmSearchWorkProgress and set its record source to a particular SQL string.

But every time I click the button it says that Access cannot find the form. The form definitely exists, and I've copied and pasted the name to be sure I didn't key it wrong. The Project Browser certainly shows it as one of the db objects. I tried saving, compacting/repairing, and reopening the db just in case. I'm bewildered.

Any ideas as to what might be preventing my procedure from finding this form? Much appreciation for all suggestions; everyone in this forum is awesome. :yes

NM -- Problem Solved. I apologize for wasting board space on that!!

Quote:

---

Originally Posted by eed

NM -- Problem Solved. I apologize for wasting board space on that!!

---

Hey, would you mind providing the solution that you came up with? That'd be great for future reference for anyone with the same problem. :) Thanks!

The form, most likely, was not open while he was trying to reference it.