My 1st loop attempt needs help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have for the past few days tried to solve this by myself, no luck.
The following code is an attempt to undo the filter after opening a form
matching the "OrderID".
I want to be able to run "DoCmd.ShowAllRecords" only once.
----------------------------------------------------------------------
Dim intI As Integer

intI = 0
Do
DoCmd.ShowAllRecords

intI = intI + 1
Loop Until intI = 1
 
I'm guessing but you might just try
me.filteron = false


| Hi all,
|
| I have for the past few days tried to solve this by myself, no luck.
| The following code is an attempt to undo the filter after opening a form
| matching the "OrderID".
| I want to be able to run "DoCmd.ShowAllRecords" only once.
| ----------------------------------------------------------------------
| Dim intI As Integer
|
| intI = 0
| Do
| DoCmd.ShowAllRecords
|
| intI = intI + 1
| Loop Until intI = 1
| ---------------------------------------------------------------------------
| Can someone please help.
|
| Thanks in advance,
| Emilio
 
Thanks for your help, it was a lot simpler than I thought (if u know what u
are doing).
Emilio
 
Back
Top