M
Martin
I have a table that I call BillOfMaterials. Among the fields are Part
Number, Stage, and Resource Code. Essentially, there can be multiple
Resource Codes in multiple Stages for each Part Number. (The Stage tells
when that Resource Code is used in the production of the Part Number.)
What I would like to be able to do is to allow the user to enter the Part
Number, then be able to enter as many Stages and/or Resource Codes as needed
to build the Bill of Materials. From what I have read in the groups, I think
I need to use a Continuous Form for the "repeated" fields. The main form has
the Part Number and the subform has Stage and Resource Code.
I beilieve I set up the Form/Subform correctly, both pointing to the same
table, but only using the fields that each will be using. When I try to
enter data, I see several strange things:
1) Any time I try to type a value in the subform, I get an error "The
object does not contain the Automation object PART NUMBER". I can close the
error window and the form displays another line of default values as the next
line. I can continue entering Stage and Resource Code for the original line.
2) After I complete the first set of Stage and Resouce Code, I get an error
telling me to enter a value for PART NUMBER, even though I had entered it
before getting to the subform. This line of "new" data is not being stored
in the table. However, the line containing the default values is being
stored.
3) If I want to accept the default values for Stage and Resource Code, I
can tab thru the fields, but I will not get another line for another set of
fields. The cursor simply rotates around the one line. However, the line is
stored in the table, but only one time, regardless of how many times I
rotates thru the fields.
I apologize for the length of this, but I wanted to be as clear as possible.
If anyone can help me get this right, it would be appreciated. Please be as
specific as possible as I am new to working with subforms.
Thanks.
Number, Stage, and Resource Code. Essentially, there can be multiple
Resource Codes in multiple Stages for each Part Number. (The Stage tells
when that Resource Code is used in the production of the Part Number.)
What I would like to be able to do is to allow the user to enter the Part
Number, then be able to enter as many Stages and/or Resource Codes as needed
to build the Bill of Materials. From what I have read in the groups, I think
I need to use a Continuous Form for the "repeated" fields. The main form has
the Part Number and the subform has Stage and Resource Code.
I beilieve I set up the Form/Subform correctly, both pointing to the same
table, but only using the fields that each will be using. When I try to
enter data, I see several strange things:
1) Any time I try to type a value in the subform, I get an error "The
object does not contain the Automation object PART NUMBER". I can close the
error window and the form displays another line of default values as the next
line. I can continue entering Stage and Resource Code for the original line.
2) After I complete the first set of Stage and Resouce Code, I get an error
telling me to enter a value for PART NUMBER, even though I had entered it
before getting to the subform. This line of "new" data is not being stored
in the table. However, the line containing the default values is being
stored.
3) If I want to accept the default values for Stage and Resource Code, I
can tab thru the fields, but I will not get another line for another set of
fields. The cursor simply rotates around the one line. However, the line is
stored in the table, but only one time, regardless of how many times I
rotates thru the fields.
I apologize for the length of this, but I wanted to be as clear as possible.
If anyone can help me get this right, it would be appreciated. Please be as
specific as possible as I am new to working with subforms.
Thanks.