WHY ??? When I FILTER a FORM my TextBox gets disabled !!!

[marco02]

Hi,

I have a form retrieving a table's data. I added to this form a TEXT_BOX + COMMAND_BUTTON for filtering purposes.

1) The user enters his filtering criteria in the TEXT_BOX
(filter to be applied to the form itself)

2) Then the user presses the COMMAND_BUTTON to launch the
filtering process.

3) My code closes the form, and re-opens it FILTERED.

It works fine ... except that in the re-opened form the TEXT_BOX gets LOCKED. I can't type anything in it anymore..

>> Why ?

I want my user to be able to filter the form back and forth.

>> My code to re-open my form uses the filter command:
>> DoCmd.OpenForm "My_Form",acNormal, "QueryName_Filter", ,
acFormReadOnly, acWindowNormal

So why is Access locking my TEXT_BOX ??!! ACCESS
Any hint would help ! Thanks in advance !

Marco.

 

[RiverGuy]

How about instead of doing a filter, change the recordset property? SELECT * FROM Whatever WHERE Whatever.Whatever = " & variableCriteria & "; ". And then refreshing the form?

 

[shelron]

>> My code to re-open my form uses the filter command:
>> DoCmd.OpenForm "My_Form",acNormal, "QueryName_Filter", ,
acFormReadOnly, acWindowNormal



Just taking a stab in the dark here, but is it the "acFormReadOnly" that is locking the text box??