Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Setting Filters greys out all the buttons in my form!

Setting Filters greys out all the buttons in my form!

Setting Filters greys out all the buttons in my form!


I want to use a button to set a filter-by-form so my users can set a filter and find the record they want. I have this code:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 0, 0, acMenuVer70
in the button properties. the only problem is, when i do this, all the control buttons grey out and i can't click the "apply filter" button! i have to click "filter-apply filter/sort" in the menu bar. is there any way to un-grey the button? ideally, i'd like to have a "edit filter" button, that, when pressed, greys out all buttons except for "apply filter" and "clear filter"...

any ideas?

RE: Setting Filters greys out all the buttons in my form!

If you want to make a form you have a lot more control.
A form is easy with the wizard.

Click the Tables TAB and single click your table
Then click the "Insert" menu then "Autoform" (at the bottom)
In a few seconds it will make a form.

Now in design view of your form.  click the "Command button" on the toolbar. drag a button to your form.

When the dilog box pops up click the "Find Record" button (second in the "Actions" list).  Then follow prompts

This will find a record based on what you key in.
Then it will find the next record.  And leave the other button alone.

DougP, MCP
 Ask me how Bar-codes can help you be more productive.

RE: Setting Filters greys out all the buttons in my form!

um, not quite what i was after...

y`see, i'd like my users to be able to use the same form for both browsing, searching, and printing the record. (simplicity, natch) - when i`m working on it and i run the form, i can simply click filter-apply filter after setting up the conditions and it works. of course, in the final app, i will be hiding all the menu bars, so i'd like the same functionality bound to a clickbutton that is greyed out until such time as the user wants to set a filter - then all buttons _except_ the "apply filter" and "cancel filter" buttons are greyed out.

any ideas?

RE: Setting Filters greys out all the buttons in my form!

ooh, i'd also like to elaborate i`m trying to search for _two_ items: a customer and a article code, searching for a match in both. this is because some of our customers have specific requirements for their articles, eg special barcodes, decals, boxing requirements...whatever. we usually have to search through the customer file to find a previous order for the article, and this db system is replacing that.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close