User Profile
AmedMesa
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Filtered listbox with selected item to open record.
I have a listbox I have doing two things. It filters criteria based on a Textbox.Text with an OnChange event. Code works beautifully individually! Plenty of tutorials using a WHERE in an SQL statement for the listbox source. In this same Listbox I use a OnDblClick event to open a form and filter for the selected item using the Listbox.Column() property to forward the value to WHERE criteria of the opened form. Code also works beautifully individually. Here is my problem, say I do a search in the textbox and this filters the records of the listbox. For some odd reason I can no longer grab a value of the selected item in the listbox. Further, if I right-click to copy the field it gives me a error telling me "there isn't enough memory" which is absurd thinking the data is a few bytes on a 16GB RAM memory system. I'm scratching my head on this one for a couple of days. I tried Listbox.Value even.....doesn't matter! Again, the code works as desired individually, but I have no way of pulling data from the listbox once I apply a filter to its contents based on a form's textbox.1.5KViews0likes2CommentsCombo box with "All" added to query and sorted on top.
I have a category list that will be added to a combo box. Here is my SQL.... SELECT tblCategoryList.Category FROM tblCategoryList UNION SELECT "All" FROM tblCategoryList ORDER BY tblCategoryList.Category; So the code works, my problem is that I want the added text "All" to be placed on top of the list produced. When there is a category that contains special characters it is placed on top of "All".Solved1.7KViews0likes4Comments