String Problem

Im trying to send the following string to refresh a crysal report but sadly I receive the error message 'Run Time Error 20515 - Error In Formula '{ProgrammeSummary.ProgrammeNumber}=AV137'
A number, currency amount, boolean or string is expected here.

Any suggestions?
Many thanks,
Stephen

Dim sSelect As String
sSelect = "{ProgrammeSummary.ProgrammeNumber}=" &
txtProgrammeNumber.Text

rep1.ReplaceSelectionFormula (sSelect)

StephenHancox

Newbie Poster

6 posts since Jan 2005

Reputation Points: 10

Solved Threads: 0

6 Years Ago

Hmn, I don't know if it matters a whole lot, but in your first selection string, you have single quotes ' ' around the { }=AV137, but in the sSelect variable, you don't have those.... I'm not sure it matters, but maybe sticking them around txtProgrammeNumber.text would work?

Comatose

Taboo Programmer

Team Colleague

2,910 posts since Dec 2004

Reputation Points: 361

Solved Threads: 215

This article has been dead for over three months

You