Keeping a Button Enabled

D

DS

When I apply this command from a Command Button

acCmdFilterByForm

All of my buttons become disabled. I tried keepig a Button enabled by
adding this code
Me.Button.Enabled=True
But this doen't work, any suggestions?
Thanks
DS
 
V

Van T. Dinh

If you use Filter-By-Form, all CommandButtons on the Filter Form will be
disabled until you get back to your normal Form.
 
D

DS

Van said:
If you use Filter-By-Form, all CommandButtons on the Filter Form will be
disabled until you get back to your normal Form.
Click to expand...
Right, But how can I Overide or sidestep this, I need to get the apply
filter command going without the toolbar.
Thanks
DS
 
V

Van T. Dinh

I think the Filter Form created by the acCmdFilterByForm is *another* Form
overlaid on top of your original Form. You get what Access has been
programmed to do.

If you want to do anything different, you need to create your own Form as a
filter Form.
 
D

DS

Van said:
I think the Filter Form created by the acCmdFilterByForm is *another* Form
overlaid on top of your original Form. You get what Access has been
programmed to do.

If you want to do anything different, you need to create your own Form as a
filter Form.
Click to expand...

That helps...maybe I'll try to emulate it. Do you know where these
forms live and if they can be accessed and changed.
Thanks
DS
 
D

DS

DS said:
That helps...maybe I'll try to emulate it. Do you know where these
forms live and if they can be accessed and changed.
Thanks
DS
Click to expand...
Actually, I did just that, I copied my first form, dimmed out some of
the buttons, changed text on a few ohers and made all of the fields
unbound. Now I'll do the code to find the info. This will give me
exactly what I wanted...a filter by form, that looks great! Tank you.
DS
 
Top