Hello,

I am trying to do a data report on the current record for the table ROS. I do not want all of the records in the table.

FormROS.TextJobID.Text contains the ID of the record I want to report on.

The sql statement:
Select * from ROS where 'Job ID' = FormROS.TextJobID.Text

Gives me the error:
"FormROS.TextJobID.Text has no default value"

Any ideas?

Thanks,

Dan