Member Avatar for StephenHancox

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 <Record_Selection>'{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)

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Comatose
Member Avatar for Comatose

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.