RE:Form, SubForm, DataEntry issue
I have a data entry situation were I'm attempting to relate many information items to a few information items. I am working with a form and a subform. My goal is to create textboxes in the subform which do 2 things:
1)For each entry into subform they need to Automatically replicate what was entered into a corresponding text box located outside of subform and within mainform.
2)To populate table along with relating information entered into subform.
I've attempted to link the subform textboxes to both their corresponding mainform textboxes and a table where the information is to be collected with the following code:
=[Forms]![DataEntry_Master]![Subject_No] And [Catalog_DataEntry]![Subject_No]
but I get a #Name? error message within the subform textboxes when they appear in form view.
Any help would be much appreciated.
Thanks in advance,
Michael
I have a data entry situation were I'm attempting to relate many information items to a few information items. I am working with a form and a subform. My goal is to create textboxes in the subform which do 2 things:
1)For each entry into subform they need to Automatically replicate what was entered into a corresponding text box located outside of subform and within mainform.
2)To populate table along with relating information entered into subform.
I've attempted to link the subform textboxes to both their corresponding mainform textboxes and a table where the information is to be collected with the following code:
=[Forms]![DataEntry_Master]![Subject_No] And [Catalog_DataEntry]![Subject_No]
but I get a #Name? error message within the subform textboxes when they appear in form view.
Any help would be much appreciated.
Thanks in advance,
Michael
