i got trouble in passing my variable from a form to show a data(some data not all) using query, such as "select * from table where field = '" & text1.text & "'
i could't pass the variable when i call the data report using show..
do anyone knows what i have to do...
thanks very much
In your command inside your data environment, Create with your sql an parameter such as:
"select * from yourtable where data = MyData"
than at the properties of the command select parameters
There it should be already appeared 'MyData'
After this you should describe by selecting the type of your parameter, in your case date
After this before you execute your command set value of the parameter
dataenv.mycmd.parameter(0).value = date
dataenv.mycmd.execute
You should figure out..., good luck