Listbox on a form as input for a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All

I have an unbound multi-select listbox on a form. I am getting values from a column into the listbox. I want the values selected to be input for a query. So, in the query, under the column, i have forms![nameofform]![nameoflistbox]. i also have a macro to run the query when the selections are made on the list box. when i run the form, i get "The microsoft jet database engine does not recognize 'forms![nameofform]![nameoflistbox]' as a valid field name or extension

Any help would be greatly appreciated

Thanks

Malli
 
You cannot use Multi-Select ListBox the way you described.

See The Access Web article:

http://www.mvps.org/access/forms/frm0007.htm

--
HTH
Van T. Dinh
MVP (Access)



Malli said:
Hello All,

I have an unbound multi-select listbox on a form. I am getting values from
Click to expand...
a column into the listbox. I want the values selected to be input for a
query. So, in the query, under the column, i have
forms![nameofform]![nameoflistbox]. i also have a macro to run the query
when the selections are made on the list box. when i run the form, i get
"The microsoft jet database engine does not recognize
'forms![nameofform]![nameoflistbox]' as a valid field name or extension.
 
Back
Top