Data Reports

I have a form with a text box and a command button.

If i click the button a report should be generated for the number which i have entered in the text box.

If i pass the query in the Dataenvironment as below
it works fine.

select * from client_table where(number='c.c.no1')

How should i pass the query to place the text box value instead of the above value.

If u could not understand the question plz mail me

@ vivek_g_r@rediffmail.com

Thanx

Vivek
vivek_chozhaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Anthony PerkinsConnect With a Mentor Commented:
Assuming your text box is called Text1 than your SQL statement should look like:

"select * from client_table where number='" & Text1.Text & "'"

Anthony
0
 
vivek_chozhaAuthor Commented:
Thanx a lot Antony.

I will soon contact thru mail.

Thanx once again.

0
All Courses

From novice to tech pro — start learning today.