Return without GoSub

  • Thread starter Thread starter Big Wes
  • Start date Start date
B

Big Wes

Hello and thanks for helping. I have found many references to this
error but none seem to fit. I have a pop-up form where I make a
selection which runs a macro. The macro is meant to minimize the
current form, open a different form, apply a filter based on my
selection, then close the pop-up form. The pop-up minimizes and the
main form opens, but somewhere after that the error occurs. I believe
it is happening in the application of the filter as this step does not
appear to complete.

Any advice is greatly appreciated.
 
Big Wes said:
Hello and thanks for helping. I have found many references to this
error but none seem to fit. I have a pop-up form where I make a
selection which runs a macro. The macro is meant to minimize the
current form, open a different form, apply a filter based on my
selection, then close the pop-up form. The pop-up minimizes and the
main form opens, but somewhere after that the error occurs. I believe
it is happening in the application of the filter as this step does not
appear to complete.

Any advice is greatly appreciated.
Click to expand...


When you refer to a "macro", do you mean a VBA procedure, or are you talking
about a macro as Access uses the term -- written in the macro editor? If
it's a VBA procedure, as it sounds, please post the code of the procedure
and any other procedures that may be called as a result of its execution.
When the error occurs, can you click Debug and see which line of the
procedure is highlighted?

If it's a true macro, please post the details of the macro.
 
Thanks Dirk. I am referring to an actual macro as Access refers to
it. When the error occurs, it does not give me the option to debug -
just click ok. It reads:

Name: AddressSearch


Minimize

OpenForm (Opens the form that displays the addresses with all
addresses shown)
[Forms]![FilterForm]![Active] Is Not Null ApplyFilter
[Forms]![FilterForm]![Inactive] Is Not Null ApplyFilter
[Forms]![FilterForm]![ActiveList] Is Not Null ApplyFilter
[Forms]![FilterForm]![All] Is Not Null ApplyFilter

Close (closes the Filter Form)
 
Big Wes said:
Thanks Dirk. I am referring to an actual macro as Access refers to
it. When the error occurs, it does not give me the option to debug -
just click ok. It reads:

Name: AddressSearch


Minimize

OpenForm (Opens the form that displays the addresses with all
addresses shown)
[Forms]![FilterForm]![Active] Is Not Null ApplyFilter
[Forms]![FilterForm]![Inactive] Is Not Null ApplyFilter
[Forms]![FilterForm]![ActiveList] Is Not Null ApplyFilter
[Forms]![FilterForm]![All] Is Not Null ApplyFilter

Close (closes the Filter Form)
Click to expand...


It looks to me as if we should look at the form you're opening to see if it
has code in any of its events that might be the source of the problem. Do
you get an error if you just open that form? How about if you open it with
no records displayed?

Does that form (the address form you're opening) have any code at all? If
so, could you post the code from its module? Of immediate interest is any
code in the Open, Load, ApplyFilter, or Current events.
 
Back
Top