Access 2000 RecordSource and left Joined Tables

M

Michael

I have set the RecordSource to select only active or
inactive files from a combo box in my form that part works
great. Except for a few fields in the Foarm SHOW #NAME?
The fields are in tables that are Right joins in the SQL
statement behind the form. How do I get around that.
 
Top