Expected end of statement in Where clause plz help in fixing syntax

[SAM453]

It's says expected end of statement in where clause
Can any one fix this plz

str = "SELECT Dump_BC_AP_DATA_DUMP.AP_Id, Dump_BC_AP_DATA_DUMP.Transaction_Type, " & _
" Dump_BC_AP_DATA_DUMP.Business_Unit_Id, Dump_BC_AP_DATA_DUMP.Station_Id, " & _
" Dump_BC_AP_DATA_DUMP.Business_Date, Dump_BC_AP_DATA_DUMP.Supplier_Id, " & _
" Dump_BC_AP_DATA_DUMP.Supplier_Name, Dump_BC_AP_DATA_DUMP.Supplier_Xref_Code, " & _
" Dump_BC_AP_DATA_DUMP.Supplier_Edi_Number, Dump_BC_AP_DATA_DUMP.Supplier_Terms, " & _
" Dump_BC_AP_DATA_DUMP.Transaction_Id, Dump_BC_AP_DATA_DUMP.Transaction_Date, " & _
" Dump_BC_AP_DATA_DUMP.Transaction_Number, Dump_BC_AP_DATA_DUMP.Control_Number FROM Dump_BC_AP_DATA_DUMP INNER JOIN lkp_vwStore ON Dump_BC_AP_DATA_DUMP.station_ID=lkp_vwStore.Station_ID WHERE ([lkp_vwStore].[dsm_name]) = [Forms]![BC3]![Combo13] & _
" and ([Dump_BC_AP_DATA_DUMP].[Business_Date]) Between [Forms]![BC3]![text0] and [Forms]![BC3]![text3]" & _
" order by Dump_BC_AP_DATA_DUMP.Station_Id ;

 

[dhookom]

I typically break these into smaller sets of

str = "SELECT ...."
str = str & " FROM ..." & _
  "   "
str = str & " WHERE ...." & _
  "   "
str = str & " ORDER BY ...." & _
  "   "

There are limits to the number of line continuations and the length of the full string.
It looks like you might be missing a " in

 ...[Forms]![BC3]![Combo13]  & _

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya SAM453 . . .

[blue]dhookom[/blue] has you:

[blue]   = [Forms]![BC3]![Combo13][COLOR=yellow red] "[/color] & _[/blue]

He's also correct about the number of line continuation characters you can have. My last count it was [blue]18 to 20[/blue].

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]