Recent content by swes912

I took Set out and just did stSQL = ..... And it worked. Thanks for the help

yes i did change the names. This is what the new code looks like If IsNull(Me.[lstMonth]) Then MsgBox "Please highlight a Month.", vbOKOnly End If If IsNull(Me.[lstYear]) Then MsgBox "Please highlight a Year.", vbOKOnly End If Dim con As Object Dim rs...

I tried both of your recomendations. I seperated the code to diff lines using stSQL = stSQL & ..... and I get the same compile error on every variable even on Me![lstYear]. Is there some setting that I am missing. Kinda at a loss!

I am trying to run a query in VB and every time it gets to the query I get a Compile Error: Object Required for stSQL. Any ideas on what is going on???? Private Sub cmdStartForm_Click() If (Me![lstMonth].Value = Null) Then MsgBox "Please highlight a Month.", vbOKOnly End If...

compile error: object required- - - -Help! On a form I am trying to update a table with Month and Year that user chooses. I did a test and know that the date from the form is coming through good. The error I get is a compile error object required on the Set stSQL = "......." Private Sub...