Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting a Form

Status
Not open for further replies.

medium

MIS
Aug 28, 2002
30
US
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")
 
the form needs to be open... that's my first thought...

hope that helps...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top