Merlyn
Last Activity: Jun 14 '12, 06:23 AM
Joined: Mar 16 '12
Location:
-
Mihail: thank you so much!!! This was what I was looking for! Your attached example was the solution I needed. -
I don't have a textbox control, I only have a combobox. By entering a few characters in the combobox I want to fiter the results shown.Leave a comment:
-
Thank you for your reply, sorry I haven't been clear about what I want to do.
The subform only shows a Combobox, not a Textbox.
As rowsource of the Combobox I now entered:
according to NeoPa's answer. But that doesn't show any filtered results.Code:SELECT * FROM tblOnderwerp WHERE ([Onderwerp] Like '*' & Forms!frmZoekRegistraties!subformRegistraties!Onderwerp & '*') ORDER BY [Onderwerp];
I thought of trying what...Leave a comment:
-
Searching results in Combobox in subform with 'Like'
Hi,
I have a form with a subform. On the subform a combobox is shown. It contains over 500 items. I want to offer the users to find results containing the entered letters. (Eg. when entering "for", the results "effort", "ford" and "therefore" should be shown).
So in the properties of the combobox I use this as the rowsource:
...Code:SELECT tblOnderwerp.*, tblOnderwerp.Onderwerp
No activity results to display
Leave a comment: