Compile Error - Pleaase help me! I am drowning here!!

[downunder169]

PLease help me I am pulling my hair out here, (and I dont have enough for that).
I am trying to set up a switchboard, I do everything up to openning it and the I get this message:
Compile Error: User defined type not defined.
It then opens the debug module and the following area is highlighted:

(HIGHLIGHTED)rivate Sub FillOptions()(END HIGHLIGHT)
' Fill in the options for this switchboard page.

' The number of buttons on the form.
Const conNumButtons = 8

Dim (YELLOW)dbs As Database(END YELLOW)
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Intege

(for the literal amongst us I included the highlights and yellow to show what was on the form!!)

If you can help please let me know asap, as i am getting more and more frustrated.
either post here or email me at downunder169@hotmail.com

MAny thanks.
Thanks Talismanic, I tried it but didnt know what I was looking for!!!
By the way it is Access 97.

[This message has been edited by downunder169 (edited 06-05-2001).]

 

[Talismanic]

Is this Access 2000 or 97K?

Open a new module and check Tools > References to see if any are missing.

 

[KDg]

Hi down,

if you've directly copied that code from your module then it's almost certainly the
Dim intOption As Intege that's giving you a problem. Access is expecting you to have defined Intege as a data type somewhere, if you just drop an r on the end you should be sorted,

HTH

Drew