Running macros in subforms

Idjit

Clamoring Preschooler
Local time
Today, 18:30
Joined
Apr 18, 2002
Messages
216
I'm having some trouble getting getting macros to run within a subform. As an example, my interview asks whether a person is on any medications. If they are, the form goes to a continuous subform based on a table that stores the information 1 record/medication. I'd like to have the ability to use skip patterns within the form (filling in some fields based on the response to a different field and skiping to the next appropriate question), and also a button that takes the user back to the main form when all meds have been entered.

My problem is that I can't figure out a way to get macros to run within a subform. No matter how I reference the fields, I get error messages that the fields can't be located. So my question is am I missing something obvious, or is there really no way to do this? I don't know VBA well enough to program proficiently without using macros.

Thanks for any help.
 
How do you reference the fields?
something like [MainFormName]![Subformname].Form![ControlName]
 

Users who are viewing this thread

Back
Top Bottom