-1

I have a SQL statement for a cascading combo box. I am getting a syntax error. Any clue on how I remedy this issue?

Form_frmNewHRTPAction.cboSiteBureau.RowSource = "SELECT [AgencyOgranizationDiv-Bur].BurDesc, [AgencyOgranizationDiv-Bur].DivCode" & _ "FROM [AgencyOgranizationDiv-Bur]" & _ "WHERE((([AgencyOgranizationDiv-Bur].DivCode) =" & Nz(Form_frmNewHRTPAction.cboSiteDiv) & _ "ORDER BY [AgencyOgranizationDiv-Bur].BurDesc"enter image description here

Tyrone
  • 47
  • 7
  • 1
    Should provide error messages as text, not images. Also, format your code so it is readable. You are missing spaces at end of lines so the compiled SQL all runs together. Use a variable for the SQL statement then Debug.Print variable and you will see the constructed SQL errors. – June7 Mar 13 '23 at 19:03

0 Answers0