Help

[Guest]

Hello, I am trying to create a query that will display results in a combo box
if either of my option groups on the form are null, and it isn't working.
This query works only if both option groups have a value selected. What I
would like is for the combo box to show results if either option box 1 is
selected and/or option box 2 is selected. Any suggestions to make this work?

SELECT [Equipment List].[Equipment ID], [Equipment List].[Equipment Name],
[Equipment List].[Equipment Location], [Equipment List].Description,
[Equipment List].Secondary_Grouping_ID, Secondary_Grouping.[Secondary
Description]
FROM Secondary_Grouping RIGHT JOIN [Equipment List] ON
Secondary_Grouping.[ID#2] = [Equipment List].Secondary_Grouping_ID
WHERE ((([Equipment List].Description)=[Forms]![Test_Form_4]![Frame49]) and
(([Equipment List].Secondary_Grouping_ID)=[Forms]![Test_Form_4]![Frame27]));

Thanks,
Richard Whittet

 

[Guest]

I resolved this issue by reading another thread, I guess I should've looked
there first. Thanks anyway.