Well, Variables and Objects should always be Dimensioned to tell the Access VBA what to expect when they are used.
On top of that you should also be using Error trapping to ensure that errors are reproted correctly and stop you get in an error loop.
So can you explain what you are going to use this value for when you get it?