G
Guest
I have a continuous subform linked to the main form by Date, OriginatorID and
6 Item Number fields so that when an Item Number is entered on the main form
it automatically gets entered when a new record is generated in the subform.
I have 6 more fields that correspond to each item number field to enter a
quantity. This works great until one of the Item Numbers is changed in the
main form. This starts a new set of subform records with the new Item
Numbers. The other subform records are not seen unless the the item numbers
are changed back on the main form.
I can see two possible solutions but don't know the coding involved.
One is to be able to change the subform field when the corresponding main
form field is changed instead of creating a new subform record. This is
where the orphan records are being generated now.
The other is to just link the forms by Date and OriginatorID and then
somehow have VBA code enter the Item Number in the corresponding subform
field from the main form.
I've tried various VBA codes for each and can't figure it out. Having all 6
Item Number fields linked to the main form seems to work great except for the
need to be able to change the subform at the same time the main form is
changed instead of creating a new subform record.
Thanks for any advice.
6 Item Number fields so that when an Item Number is entered on the main form
it automatically gets entered when a new record is generated in the subform.
I have 6 more fields that correspond to each item number field to enter a
quantity. This works great until one of the Item Numbers is changed in the
main form. This starts a new set of subform records with the new Item
Numbers. The other subform records are not seen unless the the item numbers
are changed back on the main form.
I can see two possible solutions but don't know the coding involved.
One is to be able to change the subform field when the corresponding main
form field is changed instead of creating a new subform record. This is
where the orphan records are being generated now.
The other is to just link the forms by Date and OriginatorID and then
somehow have VBA code enter the Item Number in the corresponding subform
field from the main form.
I've tried various VBA codes for each and can't figure it out. Having all 6
Item Number fields linked to the main form seems to work great except for the
need to be able to change the subform at the same time the main form is
changed instead of creating a new subform record.
Thanks for any advice.