Consulting

Results 1 to 3 of 3

Thread: Solved: Troubleshooting VBA Form Reference

  1. #1
    VBAX Contributor
    Joined
    Jun 2004
    Location
    Texas
    Posts
    139
    Location

    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.

    NM -- Problem Solved. I apologize for wasting board space on that!!
    With program specs this fickle, you've just got to believe in Discord.

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,906
    Location
    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!

  3. #3
    VBAX Tutor SJ McAbney's Avatar
    Joined
    May 2004
    Location
    Glasgow
    Posts
    243
    Location
    The form, most likely, was not open while he was trying to reference it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •