Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Question Unanswered: SQL Syntax Error

    Can anyone tell me what is wron with this syntax. I am using Access Projects.

    Me![cmbCTD2].RowSource = "SELECT [tblDrawings].[CTD Number] FROM" & _
    '"[tblDrawings] WHERE ((([tblDrawings].[CID]=[forms]![frmNewEst]![cmbCust]))) "

    Me![cmbCTD2].Requery

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Try this:

    Me![cmbCTD2].RowSource = "SELECT [tblDrawings].[CTD Number] FROM" & _
    '" [tblDrawings] WHERE ((([tblDrawings].[CID]='" & [forms]![frmNewEst]![cmbCust] & "'))) "

    I changed two things, first I put a space between FROM and [tblDrawings], then I broke out the control reference to be called seperately.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •