form-control macros not showing up

  • Thread starter Thread starter Terrell Miller
  • Start date Start date
T

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!
 
Terrell,

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

- Steve Schapel, Microsoft Access MVP
 
-----Original Message-----
Terrell,

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

Steve, already checked that. No events handlers on any of
the controls on the form.
 
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
 
Back
Top