SQL Quit pulling records

  • Thread starter Thread starter Michael C.
  • Start date Start date
M

Michael C.

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? Why is it giving me #NAME? on Left and
Right Joins now that I put in the RecordSource Code.
 
Verify that the name of the control is not the same as the name of a field
in the table.
 
Back
Top