E
eljest2002
I am trying to create a form based on one table “List 1â€. On this table the
fields are “Divisionâ€, “Companyâ€, “Project Nameâ€, “Includeâ€, “A%â€, “Q%†and
“Refâ€. The first three fields are already populated and I am trying to
create a form to populate the last four fields.
The main form has the following fields: “Divisionâ€, “Companyâ€, “A%â€, “Q%â€
and “Refâ€. All fields are unbound. The first two are combo boxes based on
“List 1â€, the last three are blank for data entry.
The Sub form is based on “List 1†and has the following fields: “Divisionâ€,
“Companyâ€, “Project Nameâ€, “Includeâ€, “A%â€, “Q%†and “Refâ€. Main form
Division and subform Division are parent/child fields, same with “Companyâ€.
I created it this way so that as the user selects the Division and Company
from the main form, the subform shows the related/available data in “List 1â€.
I am trying to have the subform automatically populate based on the value
entered in the subform field “Includeâ€. For example, when a user selects
main form field values for “Division†and “Companyâ€, 8 records are displayed
in the subform. The user will then enter either a Y or N in the subform
field “Include†for each record. The last three subform fields “A%â€, “Q%â€
and “Ref†I want to automatically populate with the values entered in the
related main form fields for records with “Yâ€.
I had this actually working at one point by creating an expression for the
control record for each of the latter three subform fields. However, these
fields then would not populate the underlying table, “List 1â€.
I ran into this same problem before, and wrote some code to make it all
work, however, I can’t seem to do it again. Any suggestions?
Thanks!
fields are “Divisionâ€, “Companyâ€, “Project Nameâ€, “Includeâ€, “A%â€, “Q%†and
“Refâ€. The first three fields are already populated and I am trying to
create a form to populate the last four fields.
The main form has the following fields: “Divisionâ€, “Companyâ€, “A%â€, “Q%â€
and “Refâ€. All fields are unbound. The first two are combo boxes based on
“List 1â€, the last three are blank for data entry.
The Sub form is based on “List 1†and has the following fields: “Divisionâ€,
“Companyâ€, “Project Nameâ€, “Includeâ€, “A%â€, “Q%†and “Refâ€. Main form
Division and subform Division are parent/child fields, same with “Companyâ€.
I created it this way so that as the user selects the Division and Company
from the main form, the subform shows the related/available data in “List 1â€.
I am trying to have the subform automatically populate based on the value
entered in the subform field “Includeâ€. For example, when a user selects
main form field values for “Division†and “Companyâ€, 8 records are displayed
in the subform. The user will then enter either a Y or N in the subform
field “Include†for each record. The last three subform fields “A%â€, “Q%â€
and “Ref†I want to automatically populate with the values entered in the
related main form fields for records with “Yâ€.
I had this actually working at one point by creating an expression for the
control record for each of the latter three subform fields. However, these
fields then would not populate the underlying table, “List 1â€.
I ran into this same problem before, and wrote some code to make it all
work, however, I can’t seem to do it again. Any suggestions?
Thanks!