I have a data entry form that is bound to a table. The form has Option Group buttons that pass values to the table based on user selection. When the user chooses false the form is setup to pass 'N/A' to other fields in the same table and they are done entering the data.
My issue:
When user selects 'False' I want specific fields on the form to pass into a second table so i dont have to key this data again. I'm sure my table structure is bad. I dont want this second table to contain all records in first table. Here is code i have now:
If Me.grpFwdExclTst2.Value = "False" Then
Me.Forward_Exclusion_Test_3.Value = "N/A"
Me.Forward_Exclusion_Test_4.Value = "N/A"
Me.Embedded_Optionality_Test_1.Value = "N/A"
Me.Embedded_Optionality_Test_2.Value = "N/A"
Me.Embedded_Optionality_Test_3.Value = "N/A"
Me.Volumetric_Optionality_Test_1.Value = "N/A"
Me.Volumetric_Optionality_Test_2.Value = "N/A"
Me.Volumetric_Optionality_Test_3.Value = "N/A"
Me.Volumetric_Optionality_Test_4.Value = "N/A"
Me.Volumetric_Optionality_Test_5.Value = "N/A"
Me.Volumetric_Optionality_Test_6.Value = "N/A"
Me.Volumetric_Optionality_Test_7.Value = "N/A"
When the form opens there are fields that the user enteres that i want to pass through to the second table(with identical naming) only when the user selects false though. Ideas?? Let me know if you need additional information....
My issue:
When user selects 'False' I want specific fields on the form to pass into a second table so i dont have to key this data again. I'm sure my table structure is bad. I dont want this second table to contain all records in first table. Here is code i have now:
If Me.grpFwdExclTst2.Value = "False" Then
Me.Forward_Exclusion_Test_3.Value = "N/A"
Me.Forward_Exclusion_Test_4.Value = "N/A"
Me.Embedded_Optionality_Test_1.Value = "N/A"
Me.Embedded_Optionality_Test_2.Value = "N/A"
Me.Embedded_Optionality_Test_3.Value = "N/A"
Me.Volumetric_Optionality_Test_1.Value = "N/A"
Me.Volumetric_Optionality_Test_2.Value = "N/A"
Me.Volumetric_Optionality_Test_3.Value = "N/A"
Me.Volumetric_Optionality_Test_4.Value = "N/A"
Me.Volumetric_Optionality_Test_5.Value = "N/A"
Me.Volumetric_Optionality_Test_6.Value = "N/A"
Me.Volumetric_Optionality_Test_7.Value = "N/A"
When the form opens there are fields that the user enteres that i want to pass through to the second table(with identical naming) only when the user selects false though. Ideas?? Let me know if you need additional information....