error 3077 missing operator????

[OzzieGeorge]

I'm running the following (if it's simplistic don't laugh I havent touched VB for 7 years and I wasn't that good then).


Private Sub Custlist_Click()
Dim comport As Integer
Dim BaudRate As Integer
Dim NoToCall As String
Dim Hostvar As String
Dim IPAddress As String
Dim IPPort As String
Dim findstr As String
rscustRS.FindFirst ("PbxAlias=" & Custlist.Text)
comport = rscustRS!CommPort
BaudRate = rscustRS!BaudRate
NoToCall = rscustRS!PhoneNumber
Hostvar = rscustRS!HostName
IPAddress = rscustRS!IPAddress
IPPort = rscustRS!IPPort
End Sub

The problem is that on the line beginning rscustRS it keeps stopping with the error 3077 missing operator. The value for Custlist.text was found by reading the database and clicking on it I just don't know where I'm going wrong.

Can anyone point me in the right direction?

 

[OzzieGeorge]

By the way guys where it says programmer after my name is from another forum where I do help a lot in the subject I do know something about!

 

[SkipVought]

Hi,

Seems as if this may be TEXT...

rscustRS.FindFirst ("PbxAlias='" & Custlist.Text & "'")

Skip,

_[red][/red]