PDA

View Full Version : Solved: Troubleshooting VBA Form Reference



eed
07-01-2004, 06:03 AM
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!!

Zack Barresse
07-01-2004, 08:06 AM
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!

SJ McAbney
07-07-2004, 01:02 AM
The form, most likely, was not open while he was trying to reference it.