Grayed out command buttons on forms

[freddienet]

I have designed a form linked to a database with multiple fields. I have added a filter by form button to the body of the form.
When I click the filter by form button I can then select from the pull down menu that shows all information in each field, I can select what to filter by. The problem is that the apply filter button on the form is grayed out. The apply filter button on the Access toolbar is active and applies the filter and I get the results that I want.
I need to be able to select and apply the apply filter button on the form so I can let users use the form without naviagating thru the tool bar.
Why are the command buttons that I added grayed out?

Freddie

 

[cable]

you've got controlname.enabled=false somewhere!

 

[freddienet]

Thanks for the response

you've got controlname.enabled=false somewhere!

Can you give me an idea of where the =false might be?

Thanks,

Freddie

 

[RichO]

Are these command buttons always "disabled" or just at certain times? If they are always disabled, take a look at the Enabled property (data tab).

 

[freddienet]

Button to Apply fitler that I added

Are these command buttons always "disabled" or just at certain times? If they are always disabled, take a look at the Enabled property (data tab).

Command button placed on form is active with other command buttons, (filter by form), the instant that I click the filter by form button the other buttons gray out. I just noticed that if I position the mouse over the apply filter button and right click it gives me the option to apply filter. Applying the filter by clicking filters the information and accomplishes just what I am looking for.

Thanks
Freddie

 

[cable]

Filter by form should grey out/disable the buttons afaik.

You put the filter conditions in any/all of the fields then apply the filter, it will the renable everything, and show just those records that match your conditions.

 

[freddienet]

Just a little confused yet

Filter by form should grey out/disable the buttons afaik.

You put the filter conditions in any/all of the fields then apply the filter, it will the renable everything, and show just those records that match your conditions.

Where do I put the conditions?
In the code, in the form design, or in the data design view?

Thanks,

Freddie

 

[cable]

On the toolbar click the 'Filter By Form' Button (2 right from the z->a sort).
The toolbar will change, the buttons will all be disabled, and the form will clear.

You can now enter criteria in as many boxes as you like. Eg if you had a name field and wanted all names starting with G then you would enter G* into that field. Once you have these conditions then you can hit the 'Apply Filter' button (next to the red x)

The filter will then be applied, and you should have less records to navigate than normal, and next to the count it will remind you by saying 'filtered'

To remove the filter press the apply filter button again (it will be sunken)

Any more than that, you'll need to look in the help as I don't use it. I use the single field filter, where I just right click in a field, and enter the critera.