Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clearing Server Filter property in Access adp form

Status
Not open for further replies.
emuti

emuti

MIS
Apr 18, 2001
37
US
I've built a listbox, whereby a user can select one or multiple items, and then a filtered form opens up with the criteria specified.

I'm doing this in an access adp. However, it seems like the serverfilter property of the form will not clear out when i close the form. I even added the followign lines in the OnClose event of the form:

Me.ServerFilter = ""
Me.Filter
Me.Refresh

Does anyone have any idea to resolve this?

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
413
Chriss Miller
C
leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
572
dhookom
dhookom
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
773
Volvere
V
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
874
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
391
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top