Can I enter search criteria without "Filter by Form"

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

ljubo lecic via AccessMonster.com

I have a simple form with one of the field defined
as autonumber(Field1) in the table design.I am wandering if it is possible
to adjust behevior of that field
in a manner that I can enter a value in that field
BUT that value to be regarded as a search(filter) criterium.In other words
I want to be able to define
search criteria without having to use "Filter by form"
"Apply filter" combination on the toolbar ,that is, as
soon as I enter that field form should know that I
want to search for the specific record based in the value
I entered in that field.
Thanks in advance!
 
Use right-click on the Control and (if you haven't disabled the Shortcut
Menu), you should have the "Filter Form" option which you can use.
 
Thanks Van,
My conditional formating option is disabled.
How can I enable it again?
 
When I right click the control there is not Filter Form
option. Shortcut menus in the startup are on.
 
It is "Filter For" option with a TextBox that you can enter your criteria,
not "Filter Form"

It is the 3rd row in the Shortcut Menu.

If you don't see this, check your Form "Shortcut Menu" (set toYes) and
"Shortcut Menu Bar" (leave blank) Properties.
 
Thanks Van,
It's OK now.
BUT, Is it possible to enter value exectly into the
control and to have the same effect OR could I
write the procedure which would automatically open the
window and put focus into the FILTER FOR field as soon
as I enter my control.
Van, sorry If make too many questions but I am
newcomer without time to read much in the books.
 
Sorry, I don't know as IMHO, it is too confusing for the users. In your
set-up, entering a value in this Control means filtering but entering a
value in another Control means editing the data. I am not sure I trust my
users to that level.
 
Back
Top