H
hamsa
Hello,
My form displays a combo box populated by a SQL SELECT statement. The user
will select a row from the combo box. I then want the value in a field of the
row selected in the combo box to be used as the selection criteria in a SQL
statement.
The SQL statement is a nested SELECT and the value selected in the combo box
is the selection criteria in the inner select statement.
The problem is how to pass the value selected in the combo box to the SQL
query.
Also, I have the following problem . When I call the SQL query by clicking a
button, a window popups asking me to enter the value for the parameter. I
don't want this popup to appear. What I want to acheive is that after the
user selects a row in the combo box, I want the field value to be passed to
the SQL statement's WHERE clause and the SQL should execute and display the
rows selected.
I tried to use the ON CHANGE event of the Combo box, but this then goes into
Microsift Visual basic where I need to code a call to the SQL. I don't know
anything about Visual Basic. So, if this is the way to do it, then please
give me the details of how to call the SQL from within Visual basic. If there
is another way to acheive this, that is also fine.
I am new to MS access 2007, so please give me a step by step guidance to do
this.
Thanks in Advance.
My form displays a combo box populated by a SQL SELECT statement. The user
will select a row from the combo box. I then want the value in a field of the
row selected in the combo box to be used as the selection criteria in a SQL
statement.
The SQL statement is a nested SELECT and the value selected in the combo box
is the selection criteria in the inner select statement.
The problem is how to pass the value selected in the combo box to the SQL
query.
Also, I have the following problem . When I call the SQL query by clicking a
button, a window popups asking me to enter the value for the parameter. I
don't want this popup to appear. What I want to acheive is that after the
user selects a row in the combo box, I want the field value to be passed to
the SQL statement's WHERE clause and the SQL should execute and display the
rows selected.
I tried to use the ON CHANGE event of the Combo box, but this then goes into
Microsift Visual basic where I need to code a call to the SQL. I don't know
anything about Visual Basic. So, if this is the way to do it, then please
give me the details of how to call the SQL from within Visual basic. If there
is another way to acheive this, that is also fine.
I am new to MS access 2007, so please give me a step by step guidance to do
this.
Thanks in Advance.