M
Mehbs
I created a very simple form.
There are 2 text boxes; 1 for entering account number and other to display
its desription.
I also placed buttom so when it is clicked, select statement underneath grab
the description of that part number and display on the form.
I also created a data set for 2 tables both have account# as common field.
My sql statement is:
lcsql = "select acctnum, description, table2.amount from table1 inner join
table2 on table1.acctnum = table2.acctnum
where table1.acctnum = " & me!textbox1.text
I am trying to find out how to use form's variable in select statement like
textbox1.
I am very new to C# so please bear with me.
There are 2 text boxes; 1 for entering account number and other to display
its desription.
I also placed buttom so when it is clicked, select statement underneath grab
the description of that part number and display on the form.
I also created a data set for 2 tables both have account# as common field.
My sql statement is:
lcsql = "select acctnum, description, table2.amount from table1 inner join
table2 on table1.acctnum = table2.acctnum
where table1.acctnum = " & me!textbox1.text
I am trying to find out how to use form's variable in select statement like
textbox1.
I am very new to C# so please bear with me.