only show control when filter is on

[and]

Hi everyone.

How do I do this?
My user chooses a value from a listbox on Form1, and Form2 opens showing only the record chosen. I have a button in my form footer that removes the filter to showAllrecords. This is fine. How do I hide the button when the user opens Form2 directly to show all records anyway?

Can you tell me how/point me in the right direction/link me to somewhere that will help?

TIA.

Andrew.

 

[scriverb]

Try checking the Filter property of Form2 in the OnLoad event procedure. If there is a filter then this tells you that it is being opened through the Form1 process. Don't do anything to the button. But, if the Filter property is Null then put code in to either disable or make invisible the command button.

Let me know if that gives you a shove in the right direction.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]