Excel - Access help (1 Viewer)

[Tark221]

Hi I'm populating my listbox from access but it doesnt like my SQL statement, where am I going wrong

sSQL = "SELECT * from Process where ParentName = '[cboCategory]'"

Process is a table and cboCategory is the excel form control.

The error is "No given value for one or more required peramaters.

Any help would be much appreciated.

 

[pr2-eugin]

Try,

sSQL = "SELECT * from Process where ParentName  = '" & [cboCategory] & "'"

 

[Tark221]

Thank you, spot on!

 

[pr2-eugin]

You're welcome.