Switchboard&Linking Problem? Help Please..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database and have split it. Have had to make some additions
to the front end. Added a program and when I run it it works fine. However, I
need to add it to the switchboard. I went into the Switchboard Manager and
added an item for the new program. However, when I run the program from the
swithboard it bombs, but if I run it by itself, again it works fine. Anyone
have any ideas what could be causing this? If I'm running the same program,
why does it work in one place and not the next? Help, please.
Thanks,
RandyM
 
Here's a little more info on the problem. The error message is
Runtime error 3075
Syntax error(missing operator) in query expression '[OwnerID_AnimalTbl]='

When I debug it yellows out on the CountOfAnimals statement:
Private Sub Owner_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[OwnerID] = " & Str(Nz(Me![Owner], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
CountOfAnimals = DCount("*", "tblAnimals", "[OwnerID_AnimalTbl] = " &
Me.OwnerID)
End Sub

I have no idea where to look since it works fine when I run it outside the
Switchboard. I'm at a loss, which is not that unusual for me.:)

Thanks for any help offered
RandyM
 
Back
Top