convert query to sql issue?

[siamandm]

Hi
i have a query created with designed view, i changed the view to SQL view and used in VBA code i get this error

Capture.PNG

why is this happens please?

[HansV]

You cannot refer to controls on forms when you use DAO. You can get around this by concatenating the value of the combo box into the SQL string: change

... tblSection_District_List.LocationID_FK = [Forms]![frmSummary]![cboLocation]) ...

to

... tblSection_District_List.LocationID_FK = " & [Forms]![frmSummary]![cboLocation] & ") ...

If you call this code from frmSummary, you can even use

... tblSection_District_List.LocationID_FK = " & Me![cboLocation] & ") ...

[siamandm]

thanks a lot working now:)