Can I enter search criteria without "Filter by Form"

  • Thread starter ljubo lecic via AccessMonster.com
  • 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!
 
V

Van T. Dinh

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.
 
L

ljubo lecic via AccessMonster.com

Thanks Van,
My conditional formating option is disabled.
How can I enable it again?
 
L

ljubo lecic via AccessMonster.com

When I right click the control there is not Filter Form
option. Shortcut menus in the startup are on.
 
V

Van T. Dinh

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.
 
L

ljubo lecic via AccessMonster.com

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.
 
V

Van T. Dinh

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.
 
Top