Object required error when i am using an IF statement

[Newby]

I have tried f_Update.cbxMonth.Value ; f_Update!cbxMonth.Value and me!!cbxMonth.Value for both month and year, but it doesn't like me.



The value entered is needed to run a query. Any help would be appreciated.

thanks in advance

John



Private Sub Command0_Click()
'On Error GoTo Err_Command0_Click

Dim stDocName As String
'DoCmd.SetWarnings False

If f_Update.cbxMonth.Value Is Null Or f_Update.cbxYear.Value Is Null Then
MsgBox "Need to Select both Month and Year to posted"
Exit Sub
End If
stDocName = "qa Aging ANZ GP"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "qa Aging West GP"
DoCmd.OpenQuery stDocName, acNormal, acEdit

DoCmd.SetWarnings True

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

[pbaldy]

If that's a form reference, it doesn't look correct:

Forms Refer to Form and Subform properties and controls

[ssanfu]

If f_Update.cbxMonth.Value Is Null Or f_Update.cbxYear.Value Is Null Then

This is the type of syntax used for SQL.

In VBA, the correct syntax for testing of a control in null is:

 If IsNull(f_Update.cbxMonth) Or IsNull(f_Update.cbxYear) Then

What is "f_Update" ?

[Newby]

f_Update is a form. Does that change your answer?

[ssanfu]

If it is a form and not a subform AND the control is on that form, I would try

If IsNull(Me.cbxMonth) Or IsNull(Me.cbxYear) Then

[Newby]

Great. Thanks a bunch?