Hi. I have created some
vb codes that create a form that have button for user to click. When the button is click the controls on the form i.e. textboxes, listboxes and textboxes will be copied or loaded and thus create many rows of control for the user to key in or type in information. These information will be stored in a mdb file. There is also another button on the form that calls another form (similar form) which allows the user to auto-generate rows of controls and to key in information. These forms are the same and have the same controls. The process of form launching another form which is similar is for the purpose of multi-layer information gathering. For example ..
form1 --> take in info on problem --> launch form1 --> take in info on problems that cause the problem on earlier form1 --> launch form1 --> take in info on problems that created earlier form1.
So the DB would have 1--> 1.1 --> 1.1.1 .. but all using the same form. The code to launch the same form is
Private Sub AddfrmCmd_Click(Index As Integer)
Dim frm As Form
Set frm = New ifrfrm
frm.Show
End Sub
but then how do I ensure the data entry is correct. Do I need to use a dynamic form array? I do not know how. The codes for data entry to mdb file is similar for form1.