Hi,

        I have this code in VB5.0:

Dim FromID as string    'Start IDs list From
Dim ToID as string      'End IDs list
Dim IDStr as string

FromID = Str(ReportQuery.Text1.Text)
IDStr = "{EmpID.ID} >= " & FromID
.
.
.
CrystalsReport1.DataFiles(0) = "C:\BUDGET\BUDGET.MDB"
CrystalsReport1.SelectionFormula = IDStr
.
.
.
Then I got a message saying Error in Formula < Record_Selection>
'{EmpID.ID} >= 123456789'
A string is required here

Rmk: 123456789 is the user input

put your number in inverted commas (single quote marks). It should work
then

like so : {EmpID.ID} >= '123456789'

hth

Rachel :)
----------

No! 123456789 is a user input field not a fix string!

OGA

He's on the right lines though - try something like ' & UserInputField & '

or somit like that

Dan
Bristol, England