>>>Well, that is exactly what I did, but I am not happy with referencing a variable back to a textbox value on the form that calls the report, that's all.
>
>>Why do you need to reference it back?
>
>OK, let me rephrase that: I don't like the idea of using myForm.myTextbox.myValue for the variable being used to select records in the DE of a report. There has got to be a better way.
Sorry, Winn, I went home and didn't see your message till now. Seems like Steve already answered your question and basically it's exactly what I meant and this is technique, I use.
Also you have to create a local variable
lcMyVal=thisform.textbox1.value
select * from mytable where myCode=m.lcmyVal into cursor curReport
if _tally>0
report form myReport to printer noconsole
else
=messagebox('No records!',48,'No records...')
endif
use in CurReport
If it's not broken, fix it until it is.
My Blog