How to put code in form event.

[rogdawg]

I have created a simple form in my Access database. The form has a combo box on it (cboMyCombo). I "drew" the combo box on the form using the toolbox from the Design tab of the ribbon while in "Form" view. I have insured that the combo box is named correctly.

In the form's Load event, I am trying to use that combo box in code, like this:
Private Sub Form_Load()
SomeFunctionThatExpectsComboBox cboMyCombo, true
End Sub

When this code runs, I get:
Run-time error '91':
Object variable or With block variable not set

When I am creating the code, and I type "Me." the intellisense lists the cboMyCombo box control that I created so, it appears everything is ok.

Can someone help me figure out why the control appears on the form, and why it is reflected in intellisense but, it is NULL when the code runs?

Thanks for any help you can provide.

[NoellaG]

Hi,

presuming that the content of the combobox and "True" are 2 input parameters of the function SomeFunctionThatExpectsComboBox and that the function returns a string, you can try:

Private Sub Form_Load()
dim strReturnValue as string
strReturnValue = SomeFunctionThatExpectsComboBox(me.cboMyCombo, True)
End Sub


If SomeFunctionThatExpectsComboBox is a sub, not a function, you can try:

Private Sub Form_Load()
call SomeFunctionThatExpectsComboBox(me.cboMyCombo, True)
End Sub

[RuralGuy]

How about posting the SomeFunctionThatExpectsComboBox function so we can see it?

[rogdawg]

I figured out the problem. The function I was trying to call, while passing the combo box as an argument, was defined in separate class. I was not instantiating the class before calling the function, and that was the source of the error.

The thing that confused me was that, when in break mode, if I held the cursor over the combo box argument, the tool-tip that appeared stated that the combo box was NULL so, I thought that was the cause of the problem.

So, I did some testing by looping through the combo box's item data within the Form_Load event. After I confirmed that the combo box was fine, I then realized my bone-headed mistake.

Thank you for your help. We can chalk this one up to User Brain Glitch.

[RuralGuy]

Excellent! It is always better if the OP solves their own issue and posts the solution. More learning takes place. Thank you for posting back.