"Michiel Rapati-Kekkonen" <nn@nonsense.zzwrote in message
news:%X**************@read4.inet.fi...
Hi,
I would like that my subform is immediately filtered as soon as one types
a letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s
If one continues with 'e' the subform would show the ones starting with
se.
If one would correct that to 'e' by going back and removing the 's' the
records would start with an e.
Any suggestions?
Thanks in advance
What you describe is the way that Combo Boxes work with their AutoExpand
property set to Yes (the default setting). If you would clarify what you
are attempting to accomplish, rather than how you intended to accomplish it,
perhaps someone could make a useful suggestion. Perhaps you might even use
a Combo Box, instead of a continuous forms view Form embedded in a Subform,
to perform the function you want.
Tom is correct... I am certain you can, with expenditure of time and effort,
re-implement the AutoExpand functionality for your Subform (the examples of
which I have read did so for a List Box, though I cannot imagine why they
did not use a Combo Box instead).
If you cannot get at the current content, what VBA code are you using? The
complete contents of that text box should be available in the OnChange event
should be available as its Text property -- determining whether an
additional letter has been added, or a backspace deleted one, or the
contents cleared are what will make this more of a challenge than just using
a ComboBox, which has the added benefit of preventing you from going afar
off typing several letters of a non-existent term.
Larry Linson
Microsoft Office Access MVP
Larry Linson
Microsoft Office Access MVP