Right Joins and RecordSource Help

M

Michael

All,
I put in a ComboBox to select between Active and Inactive
Records in a table, using the RecordSource Code, It works,
except now any fields from other tables that are using a
Right or Left Join in the SQL Statement behind the form
Will not pull up from the backend. The Text box in the
form showes #name?
 
Top