Qurey exception

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT UnitData.SerialNo, UnitData.Product
FROM UnitData
WHERE
(((UnitData.Product)=[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]))
ORDER BY UnitData.SerialNo DESC
WITH OWNERACCESS OPTION;

Hi, Above is a query i have in a row source of a combo box. Basically all i
want to do is for the query to ignore the WHERE statement if
"[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]" is equal to "Repair".
Ayny idea's?

TIA

Rico
 
....
WHERE
(((UnitData.Product)=[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]))
OR ([Forms]![Jobsform]![JobDetailsform].[Form]![PartName] = "Repair")
....
 
Great Thanks alot

Rico

Van T. Dinh said:
....
WHERE
(((UnitData.Product)=[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]))
OR ([Forms]![Jobsform]![JobDetailsform].[Form]![PartName] = "Repair")
....

--
HTH
Van T. Dinh
MVP (Access)


rico said:
SELECT UnitData.SerialNo, UnitData.Product
FROM UnitData
WHERE
(((UnitData.Product)=[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]))
ORDER BY UnitData.SerialNo DESC
WITH OWNERACCESS OPTION;

Hi, Above is a query i have in a row source of a combo box. Basically all i
want to do is for the query to ignore the WHERE statement if
"[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]" is equal to "Repair".
Ayny idea's?

TIA

Rico
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup Problem 4
Help with report recordsource 2
Not A Clue 4
Access Control on subform / combo box requesting parameter 0
using INSERT INTO when datas are not on DataBase 1
using a combo box value with my SQL query 3
Form automatically adds new record 2
SQL "IF" Question 5

Back
Top