ms access 2007 - SQL criteria set to form -


i have searched question , though found answer cant work

this link followed:

passing combobox value sql query ms access

here sql code im using, when run nothing comes up, have product_id selected in combo box before run there still nothing showing up.

select [1 cut wire & cable only].element   [1 cut wire & cable only]   ((                 "[1 cut wire & cable only].product_id" = [forms]![new report]!                 [cbproduct_id]         )); 

i have made sure combo box called cbproduct_id , form called new report.

[1 cut wire & cable only] name of table

i doing thing in particle wrong ?

drop double quotes, , close whitespace.

select [1 cut wire & cable only].element   [1 cut wire & cable only]   (            [1 cut wire & cable only].product_id = [forms]![new report]![cbproduct_id]         ); 

Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

qt - Errors in generated MOC files for QT5 from cmake -