Test variable in immediate window

[Richie27]

Hi all,



I have declared some variables as follows

Dim costCentre As Integer
Dim centreCostDesc As Integer
Dim centreCatDesc As Integer
Dim begDate As Date
Dim endDate As Date

And have assigned them values as follows:

costCenter = Me.cboCostCentre
centreCostDesc = Me.cboCentreCostDesc
centreCatDesc = Me.cboCatDesc

What I was wondering is how to test these values (which are from an open form with combos with values selected) in the immediate window.

I typed ?costCentre and hit enter - but nothing happens.

Any input would be great.

[RuralGuy]

A Form and its code can only be tested while the form is running. Code in a Standard module can be tested in the immediate window without a problem.

[Missinglinq]

In addition to Allan's advice, to clarify, you say

What I was wondering is how to test these values (which are from an open form with combos with values selected)

which could be construed to mean that cboCostCentre, cboCentreCostDesc and cboCatDesc are on an open Form, but not the Form whose Immediate Window is being used! Are you testing this in the Immediate Window of the Form that actually contains the Comboboxes, or from a different Form?

Linq ;0)>

[Richie27]

Yes. I am testing it in the Immediate Window of the Form that actually contains the Comboboxes and that form is open with values selected.

I put the variable declarations and assignments inside the onclick event of a button on the same form but naut happens.

Hmmmmmm

[RuralGuy]

Did you set a breakpoint so the code will stop?

[Richie27]

Did you set a breakpoint so the code will stop?

Not sure how to do that...hmmm

I'm sure this is easy......it's always things like that that stump me though......

[RuralGuy]

While viewing the code, left click outside the left margin and a dot appears. That is a breakpoint. Run the form and the code shoud stop on the line with the dot. F8 will single step the code.

[Missinglinq]

After doing as Allan has advised, placing the Breakpoint immediate after

costCenter = Me.cboCostCentre
centreCostDesc = Me.cboCentreCostDesc
centreCatDesc = Me.cboCatDesc

when you click the Command Button, the program will stop and take you to the point in code after the assignments have been made. You can then either

Use ?costCenter in the Immediate Window and hit <Enter>

or

Simply hold your Cursor over the Variable, and its Value will appear

Or, you can forget about setting a Breakpoint and simply add the Bolded line of code, below, to test the Variables:

costCenter = Me.cboCostCentre
centreCostDesc = Me.cboCentreCostDesc
centreCatDesc = Me.cboCatDesc
Debug.Print costCenter & "  " & centreCostDesc  & "  " & centreCatDesc

Then, In Form View

• Click on the Command Button
• Now go into Design View
• Go to the Code Module
• Look in the Immediate Window; the Values should be printed there

Linq ;0)>