Qurey exception

R

rico

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
 
V

Van T. Dinh

....
WHERE
(((UnitData.Product)=[Forms]![Jobsform]![JobDetailsform].[Form]![PartName]))
OR ([Forms]![Jobsform]![JobDetailsform].[Form]![PartName] = "Repair")
....
 
R

rico

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...
 
Top