Can I create a permanent filter by using the Form's Attribute “Filter”

[jlathem]

Can I create a permanent filter by using the Form's Attribute “Filter” so the records returned only show a specific value?

I have tried this but it didn’t work for me.

((Cash_Record.Current_Assignment=2))

Cash_Record is the table Current_Assignment is both the Table’s Field name and the Form Control name, 2 is the value I want to return.

I need to keep the records viewable as well as editable in the nice forms and not return them in Datasheets.

Is there a permanent script I can put in the form somewhere that will limit the returned records?

 

[dhookom]

Can you tell us what you mean by "permanent"? If you want to change it, then it isn't permanent.

I think you might be able to use a combobox or text box in the form header section and then use the value to set the Filter property. You would also need to set the FilterOn property to True.

Duane
Hook'D on Access
MS Access MVP

 

[jlathem]

I apologize for not making myself clearer. I just started using MS Access Forms, Report, and such a week ago. And I have put in over 90 hour this week with Access 2003!

I come out of the web developing world and getting my mind thinking like Microsoft seems to be a challenge for me.

I just got the problem resolved though.

I just built a query and pointed the Form’s Record Source to it.

Again I apologize and thank you for your time and efforts.

Jms