Without seeing your db, it's hard to say why. Can you share a sample copy of your db?
How to link multiple forms to a single form
i've posted this same issue on this website www.accessforums.net/showthread.php?t=83680
I want to link 6 forms to a single form
calling an especific form with a button based on an option selected on a combobox with this code
Private Sub Command4_Click()
Dim strForm As String
If Me.TipodeTramite = "Licencia Nueva" Then
strForm = "Req1"
ElseIf Me.TipodeTramite = "Cambio de Domicilio" Then
strForm = "Req2"
strForm = "Req3"
but when i add data to one of those forms it creates a new record on my table instead of putting it in the same record as my principal form
i use 2 related tables, my "primary" table stores data like "name, number of document... etc"
and the second (called requisitos) stores some requirements for those records
the form called "Datos de Empresa" displays and record data to my primary table
the forms "Req1,2,3,4,5,6" displays and record some fields from requisitos table
for example Req1 have 3 fields of the requisitos table and Req2 have another 5 fields from requisitos and so on
what can i do to link those 6 forms to my principal form?