Setting Filters greys out all the buttons in my form!

[Siridar]

hi,

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?

 

[DougP]

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
dposton@universal1.com

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

 

[Siridar]

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?

 

[Siridar]

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.