Problems with a subform

[silva]

I created a form that has a page section on it for subforms. There are seven
total pages, each with a different subform. Each subform works perfectly and
calls up yet another subform. This subform is used on all seven pages. This
subform works perfectly fine only on the first page. The other six
incarnations of it call up all of the records that were created on the first
page and don't allow new additions. When I try, it throws up an error message
stating that there isn't an associated field from the subform calling it. I
tried making copies of the original sub-subform and renaming each of the
copies appropriately, and then having the six other subforms call the renamed
copies of the sub-subform. It still doesn't work correctly. Here's
essentially what I'm doing:

The main form is for customer contact information. The subforms are each of
a different type of customer commenting (comment cards, survey, etc.). In the
event of an appropriate problem they contact our office about, we send them
free passes. The passes each have their own printed ID number. The purpose of
the sub-subform is to list any and all passes that are handed out,
associating them with each comment record, using the comment record number
and the pass number as a compound key. That can probably be changed so that
the pass number is the key.

The problem is that for six of the seven subforms, all of the pass records
show up as opposed to only those that are associated with the comment type
and comment ID #. If anyone can understand what the heck I just said, could
they tell me what I'm doing wrong?

 

[sergio.stecca]

I created a form that has a page section on it for subforms. There are seven
total pages, each with a different subform. Each subform works perfectly and
calls up yet another subform. This subform is used on all seven pages. This
subform works perfectly fine only on the first page. The other six
incarnations of it call up all of the records that were created on the first
page and don't allow new additions. When I try, it throws up an error message
stating that there isn't an associated field from the subform calling it. I
tried making copies of the original sub-subform and renaming each of the
copies appropriately, and then having the six other subforms call the renamed
copies of the sub-subform. It still doesn't work correctly. Here's
essentially what I'm doing:

The main form is for customer contact information. The subforms are each of
a different type of customer commenting (comment cards, survey, etc.). In the
event of an appropriate problem they contact our office about, we send them
free passes. The passes each have their own printed ID number. The purpose of
the sub-subform is to list any and all passes that are handed out,
associating them with each comment record, using the comment record number
and the pass number as a compound key. That can probably be changed so that
the pass number is the key.

The problem is that for six of the seven subforms, all of the pass records
show up as opposed to only those that are associated with the comment type
and comment ID #. If anyone can understand what the heck I just said, could
they tell me what I'm doing wrong?

Probably the [Subform(1)] called from other 7 [subforms(7)], includes
some a reference to a Field or Control that is in the unique FORM from
which it works correctly

For knowing where is that reference, open the [Subform(1)] and check
field by field whre is a reference with the following format. [FORMS]!
[form_name]![Field_name]

If my assumption is correct, you must change the reference to the main
form [FORMS]![main_form_name]![Field_name], and when you open anyone
of the 7 forms, be sure to move the required data to the field of the
main forms, for that, put the following command somewhere in all 7
forms: [FORMS]![main_form_name]![Field_name]=data_name

Regards

 

[silva]

I created a form that has a page section on it for subforms. There are seven
total pages, each with a different subform. Each subform works perfectly and
calls up yet another subform. This subform is used on all seven pages. This
subform works perfectly fine only on the first page. The other six
incarnations of it call up all of the records that were created on the first
page and don't allow new additions. When I try, it throws up an error message
stating that there isn't an associated field from the subform calling it. I
tried making copies of the original sub-subform and renaming each of the
copies appropriately, and then having the six other subforms call the renamed
copies of the sub-subform. It still doesn't work correctly. Here's
essentially what I'm doing:

The main form is for customer contact information. The subforms are each of
a different type of customer commenting (comment cards, survey, etc.). In the
event of an appropriate problem they contact our office about, we send them
free passes. The passes each have their own printed ID number. The purpose of
the sub-subform is to list any and all passes that are handed out,
associating them with each comment record, using the comment record number
and the pass number as a compound key. That can probably be changed so that
the pass number is the key.

The problem is that for six of the seven subforms, all of the pass records
show up as opposed to only those that are associated with the comment type
and comment ID #. If anyone can understand what the heck I just said, could
they tell me what I'm doing wrong?

Probably the [Subform(1)] called from other 7 [subforms(7)], includes
some a reference to a Field or Control that is in the unique FORM from
which it works correctly

For knowing where is that reference, open the [Subform(1)] and check
field by field whre is a reference with the following format. [FORMS]!
[form_name]![Field_name]

If my assumption is correct, you must change the reference to the main
form [FORMS]![main_form_name]![Field_name], and when you open anyone
of the 7 forms, be sure to move the required data to the field of the
main forms, for that, put the following command somewhere in all 7
forms: [FORMS]![main_form_name]![Field_name]=data_name

Regards

OK... After reading your reply, I managed to fix it. I couldn't find
anything that looked like what you were talking about. But somehow after
re-creating the sub-subform in one of the pages, two fields in the properties
window were filled in with values. These were "Link Child Fields" and "Link
Master Fields". I entered the data for those fields for all of the subforms
and they now appear to work correctly. I guess somehow the information was
never automatically entered so they didn't work. But now they do.

--silva