Runtime error 3075

[kickergirl]

I recently created a database in Access 2000 that has been distributed to multiple people using various versions of Access. Each person is using it as a standalone database.

The database has multiple forms that collect information on individual people. In fact there are 5 forms per person. The first and second form write data to the same table. The VBA code below is what happens when the user continues to the second form to enter more data. A user who has Access 2003 receives a Runtime error 3075 - Syntax error (missing operator) in query expression 'Participant_Info.'. at this point. The last line of code is what is indicated to be the problem. However, I do not get that error when testing the database in Access 2000.

Can anyone provide a hint as to the possible problem?

Thanks!

Private Sub GoToEmpForm_Label_Click()
    If IsNull(Me![SSN]) Or (Me![SSN]) = "" Then
        MsgBox "Please select a SSN before proceeding!", vbOKOnly, "Invalid Search Criterion!"
         Me!SSN.SetFocus
    Exit Sub
    ElseIf IsNull(Me!LWIA_Combo) Or Me!LWIA_Combo = "" Then
        MsgBox "Please select a LWIA before proceeding!", vbOKOnly, "Missing Entry"
    Exit Sub
    ElseIf Nz(Me.WSOther, "") = "" And Me.WIA_Stat_Opt = 4 Then
        Cancel = True
        MsgBox "Please enter 'Other Adult' WIA Status", , "Missing Entry"
        Me.WSOther.SetFocus
    Exit Sub
 
    End If
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
DoCmd.OpenForm "Emp_Info_frm", acNormal
 
End Sub
 

[missinglinq]

Since there's no reference to Participant_Info in the code here, and Access is erroring out on the line opening the form Emp_Info_frm, I'm going to guess that the problem is in the query that's the Record Source for this form. We need to see the SQL code for this query. The problem could be in a missing library on the v2003 machine that 's being referenced in the SQL.

Linq ;0)>