Hi friends,
I have added a listbox on a form to give criteria to the various queries of my database. I have decided to move to a listbox since before I was using a combo but needed the multiselect function since for some queries I wanted to select more that one record at the time.
The source of my listbox is a table name Initials. It has two fields, Initials and Employees. In he Initials field are stored the initials of my database user's while in the Employees field there is the full name of the users.
The criteria to my queries should be the Initials, therefore the records in the field Initials.
The SourceRow of my listbox is a query that was automatically built when I added to Initials table to its property.
The MultiSelect is on Simple.
Unfortunately I am not able to give criteria to my queries when I select a record. Where am I doing wrong? I have also tried just with one column (initials) but still does not work.
Thanks.
I have added a listbox on a form to give criteria to the various queries of my database. I have decided to move to a listbox since before I was using a combo but needed the multiselect function since for some queries I wanted to select more that one record at the time.
The source of my listbox is a table name Initials. It has two fields, Initials and Employees. In he Initials field are stored the initials of my database user's while in the Employees field there is the full name of the users.
The criteria to my queries should be the Initials, therefore the records in the field Initials.
The SourceRow of my listbox is a query that was automatically built when I added to Initials table to its property.
The MultiSelect is on Simple.
Unfortunately I am not able to give criteria to my queries when I select a record. Where am I doing wrong? I have also tried just with one column (initials) but still does not work.
Thanks.
