D
Dogbert Dilbert
Dear All,
I hope you can help me out here. I've been using Access for a while
now, and have recently started learning to use SQLserver.
As a test, I thought I'd make an ADP connected to a SQLserver
database, however some of the things that work in the original Access
database (and even in an Access Db linked to SQLserver) no longer seem
to work here.
One such instance is the use of a combo box to select the parameter
for use in a SQL query. I have a list of contractors (in table
CROlist) and in another table (Index - bad name, I know) information
about the work we're doing with each contractor (study number, cost,
etc). I've previously (in Access) been able to use a form with a combo
box linked to a query to allow users of the database to search for all
the information on a particular contractor by selecting the contractor
name from a combo box. I cannot get this working in ADP. I can make a
query that works, but it requires the user to enter the contractor
name, and I'd really like the user to select from a drop-down list.
I've tried to do this using a WHERE condition, but I don't know how to
refer to the item selected in the combo box.
Can anyone suggest a reasonable approach to solving this problem
(whether it uses WHERE or not)?
TIA
Dogbertd
I hope you can help me out here. I've been using Access for a while
now, and have recently started learning to use SQLserver.
As a test, I thought I'd make an ADP connected to a SQLserver
database, however some of the things that work in the original Access
database (and even in an Access Db linked to SQLserver) no longer seem
to work here.
One such instance is the use of a combo box to select the parameter
for use in a SQL query. I have a list of contractors (in table
CROlist) and in another table (Index - bad name, I know) information
about the work we're doing with each contractor (study number, cost,
etc). I've previously (in Access) been able to use a form with a combo
box linked to a query to allow users of the database to search for all
the information on a particular contractor by selecting the contractor
name from a combo box. I cannot get this working in ADP. I can make a
query that works, but it requires the user to enter the contractor
name, and I'd really like the user to select from a drop-down list.
I've tried to do this using a WHERE condition, but I don't know how to
refer to the item selected in the combo box.
Can anyone suggest a reasonable approach to solving this problem
(whether it uses WHERE or not)?
TIA
Dogbertd