Use 2 row sources??

[Guest]

I have a form that is used to base reports on and in one combo box
RP_Customer I have the field looking at tbl_Customer so what my question is
for this drop down field in the form can I have it look at this table or
select the word "All"??

In the property field for Row Source there is the following:
SELECT [tbl_Suppllier_Names].[Supplier] FROM tbl_Suppllier_Names;
So can we add an "AND" or "OR" statement or is it not possible?
i.e. SELECT [tbl_Suppllier_Names].[Supplier] FROM tbl_Suppllier_Names OR "All"

Thanks!!
Stacey

 

[UpRider]

Stacy, your rowsource now selects ALL records from tbl_Supplier_Names.
Can you elaborate on what you are trying to accomplish?

UpRider

 

[UpRider]

Stacy, your rowsource as currently listed will select ALL records from
tbl_Supplier_names.
Could you elaborate on what you are trying to accomplish?

UpRider