L
laura.dodge
Hi everyone, I'm hoping someone out there can help me with my skip
patterns. I'm using 2003 to create a form for an enormous survey.
Because it has hundreds of questions, I've made multiple subforms from
multiple tables and have put them on tab controls on the main form, so
the data entry people don't have to open up multiple forms. Being a
self-taught user, I do not know VBA, and though I'm attempting to
learn it, I'd like to figure this out sooner rather than later.
I've written macros for the skip patterns on the main form and they
doing exactly what they are supposed to (for the moment, anyway). I've
used the GoToContol, and the conditions look something like this:
[Forms]![frm Female Baseline]![008]=2
I've then specified the control name as 100. So if the answer to
question 008 is 2, the cursor will jump ahead to question 100 and skip
the now irrelevant ones in between. So far, so good.
But I'm having trouble with the subforms. When I open the subform by
itself, the skip pattern is fine. However, when I go through the main
form, to the first tab that has this subform, the skip patterns no
longer work. I get the following message: Microsoft Office Access
can't find the form 'sfm FB 212a - 212j' referred to in a macro
expression or Visual Basic code. *The form you referenced may be
closed or may not exist in the database. *Microsoft Office Access may
have encountered a compile error in a Visual Basic module for the
form.
When I open the subform in the background and enter data on the main
form, I no longer get this message, but the skip pattern doesn't do
anything at all. I don't want the data entry people to have to open
all the forms to use the main form. At that rate I might as well have
a form for each table, but we want to make this as easy as possible
and have only one form that needs to be opened. Also, it seems like
the best way to keep the subject number accurate, as opposed to having
to re-enter it eight times. Does anyone have any suggestions?
And in a related question, is there a way to skip from a question on
one tab (part of the main form) to a field on a different tab (one of
the subforms)? From what I've seen this is not possible, but hopefully
I'm missing something.
Thanks so much for the help, I really appreciate it!
patterns. I'm using 2003 to create a form for an enormous survey.
Because it has hundreds of questions, I've made multiple subforms from
multiple tables and have put them on tab controls on the main form, so
the data entry people don't have to open up multiple forms. Being a
self-taught user, I do not know VBA, and though I'm attempting to
learn it, I'd like to figure this out sooner rather than later.
I've written macros for the skip patterns on the main form and they
doing exactly what they are supposed to (for the moment, anyway). I've
used the GoToContol, and the conditions look something like this:
[Forms]![frm Female Baseline]![008]=2
I've then specified the control name as 100. So if the answer to
question 008 is 2, the cursor will jump ahead to question 100 and skip
the now irrelevant ones in between. So far, so good.
But I'm having trouble with the subforms. When I open the subform by
itself, the skip pattern is fine. However, when I go through the main
form, to the first tab that has this subform, the skip patterns no
longer work. I get the following message: Microsoft Office Access
can't find the form 'sfm FB 212a - 212j' referred to in a macro
expression or Visual Basic code. *The form you referenced may be
closed or may not exist in the database. *Microsoft Office Access may
have encountered a compile error in a Visual Basic module for the
form.
When I open the subform in the background and enter data on the main
form, I no longer get this message, but the skip pattern doesn't do
anything at all. I don't want the data entry people to have to open
all the forms to use the main form. At that rate I might as well have
a form for each table, but we want to make this as easy as possible
and have only one form that needs to be opened. Also, it seems like
the best way to keep the subject number accurate, as opposed to having
to re-enter it eight times. Does anyone have any suggestions?
And in a related question, is there a way to skip from a question on
one tab (part of the main form) to a field on a different tab (one of
the subforms)? From what I've seen this is not possible, but hopefully
I'm missing something.
Thanks so much for the help, I really appreciate it!