Folks,
My code is below. Or, here's at least the beginning of it. I have the rest. However, the debugger keeps stopping at the "SetChckot1..." line. Here is the error I'm getting. "Run-time error '2450' Microsoft Access can't find the form 'CheckOutForCodeForm' referred to in a macro expression or VB Code." Now I understand what this means. However, the form referred to is in the Form list. Moreover, I've checked the spelling a zillion times. This same error message popped in a tutorial I was doing on the same "Set ....Application.Forms..." I am running Access in a full session on Windows 2000 Server with the server residing at a remote location. Thanks for any help in advance. Does anyone know why this is occurs?
Public Function CheckOut()
'declare variables and assign address to object variables
Dim strClkNo As String, strPartNo As String, IntQuantity2 As Integer, IntQuantity As String
Dim ChckOt1 As Form
Set ChckOt1 = Application.Forms("CheckOutForCodeForm"
My code is below. Or, here's at least the beginning of it. I have the rest. However, the debugger keeps stopping at the "SetChckot1..." line. Here is the error I'm getting. "Run-time error '2450' Microsoft Access can't find the form 'CheckOutForCodeForm' referred to in a macro expression or VB Code." Now I understand what this means. However, the form referred to is in the Form list. Moreover, I've checked the spelling a zillion times. This same error message popped in a tutorial I was doing on the same "Set ....Application.Forms..." I am running Access in a full session on Windows 2000 Server with the server residing at a remote location. Thanks for any help in advance. Does anyone know why this is occurs?
Public Function CheckOut()
'declare variables and assign address to object variables
Dim strClkNo As String, strPartNo As String, IntQuantity2 As Integer, IntQuantity As String
Dim ChckOt1 As Form
Set ChckOt1 = Application.Forms("CheckOutForCodeForm"