Thanks everyone for your suggestions. I really appreciate it.
Pretty much every software I know filters the way I have in mind.
You start typing text and the form starts filtering, you type too much text and eventually the form is empty because there are literally no results for whatever you typed. I mean, I guess I agree to disagree, but there's no way that leaving results in the subform list while the search box says "afddafasdfds" makes sense.
Anyway, yes a label would make sense, but without clearing the form it really doesn't really help. What if I have multiple search boxes? It becomes confusing.
I'm assuming this is just a limitation in access and I have to go through these workarounds to achieve what I need for this particular case.
arnelgp, thank you! I will attempt what you mentioned here and report back
Pretty much every software I know filters the way I have in mind.
You start typing text and the form starts filtering, you type too much text and eventually the form is empty because there are literally no results for whatever you typed. I mean, I guess I agree to disagree, but there's no way that leaving results in the subform list while the search box says "afddafasdfds" makes sense.
Anyway, yes a label would make sense, but without clearing the form it really doesn't really help. What if I have multiple search boxes? It becomes confusing.
I'm assuming this is just a limitation in access and I have to go through these workarounds to achieve what I need for this particular case.
arnelgp, thank you! I will attempt what you mentioned here and report back