K
Keith Paschal
Guest
I've seen this question asked several times and the answers are always 'code a finite list' for the listbox source. Here's what I want to do, and why I cannot do this.
I have a table called products, and a query based on that table. The query is the source for the values in the listbox and has 4 fields: ID, SKU, Description and PictureFile (which is the path and filename of a picture). There is a textbox that you can type in and select part of the description (like: boat) and then click a button to search. This then reruns the query with LIKE "*"&txtBox&"*" to give an updated list where 'boat' is in the description. If there are 4 boats, I want the user to be able to select one of the 4 boats in the listbox and update an image outside of the listbox to reflect the picture stored in the PictureFile field. I think where I have gone wrong at this part is the source for the image, so perhaps I need to build some sort of expression in there to select the selected PictureFile that is currently in the listbox? Or would this be just much easier with a click event in the listbox to force the image (named outputImage) to be updated by the selected line (I am not allowing multi-selects in the listbox).
Continue reading...
I have a table called products, and a query based on that table. The query is the source for the values in the listbox and has 4 fields: ID, SKU, Description and PictureFile (which is the path and filename of a picture). There is a textbox that you can type in and select part of the description (like: boat) and then click a button to search. This then reruns the query with LIKE "*"&txtBox&"*" to give an updated list where 'boat' is in the description. If there are 4 boats, I want the user to be able to select one of the 4 boats in the listbox and update an image outside of the listbox to reflect the picture stored in the PictureFile field. I think where I have gone wrong at this part is the source for the image, so perhaps I need to build some sort of expression in there to select the selected PictureFile that is currently in the listbox? Or would this be just much easier with a click event in the listbox to force the image (named outputImage) to be updated by the selected line (I am not allowing multi-selects in the listbox).
Continue reading...