form-control macros not showing up

[Terrell Miller]

got an inherited app that's using macros for form-control
(if you select option six in an option group the
the "Section 6" controls enable and controls for sections
4,5 and 7 disable, etc.)

Works fine, EXCEPT:

I can't find the macros that are running, nor the handlers
that are calling them.

* Did Tool/Options to show hidden/system objects. There
are several macros that do similar form-control on another
form, but nada for the form I'm opening.

* No event handlers (either macro names or [Event
Procedure]) show up in the Properties/Events window for
the form.

* Each form has a VBA module, but there are no handler
subroutines in them. (I'm in Full Module VIew, so every
Sub for this form should show up).

* There are no other files/add-ins showing in the Projects
window in VBA.

* there are no SQL clauses in the RecordSource for the
form, just a direct link to the underlying table.

* Filter criteria are set, but Filter is disabled. FOrm
shows all records in the table.

The documentation says there are "skip pattern"
macros "embedded" in the table/form. I have no clue what
that means, or how to embed a macro in a table.

Any ideas where the macros are and how I can see them?

Many thanks!

 

[Steve Schapel]

Terrell,

First place I would look is the After Update event property of the
Option Group.

- Steve Schapel, Microsoft Access MVP

 

[Terrell Miller]

-----Original Message-----
Terrell,

First place I would look is the After Update event property of the
Option Group.

Steve, already checked that. No events handlers on any of
the controls on the form.

 

[Steve Schapel]

Terrell,

I have never heard of "skip pattern macros". I can't think of
anything that would produce the results you are seeing. But if you
like, I would be willing to have a look if you care to email me the
relevant parts of your database... Just remove the .ns from my return
email address.

- Steve Schapel, Microsoft Access MVP