Method or data member not found--but it's there!

[lwwhite]

This is driving me crazy and probably has a simple solution. Access 2003 Win XP. On a form, I have an unbound text box named "drive." I have an unbound combo box called "version" that looks up values in a table. I have a button that calls a shell statement that concatenates the values in these fields plus some other fields and some hardcoded text to create a complete path to a document to open in in FrameMaker. This is working perfectly on several other forms in my database. On this particular form, I get the "Method or data member not found" message for both drive and version, as if those controls were not on the form or were there by some other name, but I have checked and double-checked and those are the correct control names. When I'm in the VB editor and type "Me.", the dropdown includes those control names for selection.

I tried re-adding the unbound controls, letting Access assign a default name and using those names in my shell statement instead, but still no go. I've repaired the database and everything else I can think of.

Any clue why I am getting this message and what I can do to fix it? Here's my shell statement:

Shell "C:\Program Files\Adobe\FrameMaker7.1\FrameMaker.exe " & Me.drive & ":\Sourcedocs\EMRSuite\" & Me.version & "\" & Me.path & Me.sourcedoc, vbNormalFocus

[NeoPa]

Try putting in your code before your Shell() code :

Dim strTest As String
strTest = "C:\Program Files\Adobe\FrameMaker7.1\FrameMaker.exe " & Me.drive & ":\Sourcedocs\EMRSuite\" & Me.version & "\" & Me.path & Me.sourcedoc
Debug.Print strTest

and see what is displayed in the debug window (Ctrl-G from the VBA window).