How to Link multiple forms to a parent form?

[mike60smart]

Hi



This is how the tables should be related

[Solymandias]

thanks i did it the same way
but the forms just won't open on the same record as the main form, they keep adding new records :s

[mike60smart]

Hi

The only way we would be able to see your problem is for you to upload a zipped copy of the database.

[Solymandias]

Hi

The only way we would be able to see your problem is for you to upload a zipped copy of the database.

https://www.mediafire.com/file/d74mn...base4.rar/file

This is just a test, the form Datos de la empresa has a button to open the form Requisitos1 and look for the same data that is on the form Datos de la empresa but instead it just keeps showing a new record

[isladogs]

I believe this is crossposted at How to link multiple forms to a single form - Microsoft Q&A.
Am I correct?

[Solymandias]

I believe this is crossposted at How to link multiple forms to a single form - Microsoft Q&A.
Am I correct?

yes, that post is mine i posted here afeter that post because i saw the community here is more active

[isladogs]

It is important you explain when you have crossposted - please read http://www.excelguru.ca/content.php?...-cross-posters

Also, please provide a link to this thread at the other site

[Solymandias]

It is important you explain when you have crossposted - please read http://www.excelguru.ca/content.php?...-cross-posters

Also, please provide a link to this thread at the other site

i didn't knew, i posted the link already but it's waiting for moderator's revision

[mike60smart]

Hi

The Tab Controls should be linked as shown in the example attached

[davegri]

Here's a quick and dirty form/subform setup of your DB with proper linkages between the forms.

Solyman-davegri-v01.zip

[Solymandias]

Hi

The Tab Controls should be linked as shown in the example attached

thanks for the time, i will check it out

[Solymandias]

Sorry but those examples that you made weren't what i was looking for
but i finally did it
maybe you will see it as a mess but it works for this DB at least
what i did was creating only one table and put all of the fields there
then i used this code on a button to open the required form based on the combobox and make it write on the same record

Private Sub Command40_Click()Dim sSQL As String
Dim sFormName As String


If Me.TipodeTramite = "Licencia Nueva" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Propietario y/o Razon Social" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req1"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Domicilio" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req2"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Cambio de Giro" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req3"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Suspension Temporal de Actividades" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req4"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
ElseIf Me.TipodeTramite = "Reanudacion de Actividades" Then
sSQL = "ID_Exp=" & Me.ID_Exp
sFormName = "Req5"
If Not Me.NewRecord Then
DoCmd.OpenForm _
FormName:=sFormName, _
DataMode:=acFormEdit, _
WhereCondition:=sSQL
End If
Else
strForm = "FormC"
End If


End Sub

and here is the file https://www.mediafire.com/file/pvvtl...coh.accdb/file

i'm really thankful with all of you

[mike60smart]

Hi

If you are putting everything in 1 table why are you using Access?

Access is design to work with Multiple tables that are related.

I would suggest that you have gone the quickest but wrong route to get an answer.

[Solymandias]

Hi

If you are putting everything in 1 table why are you using Access?

Access is design to work with Multiple tables that are related.

I would suggest that you have gone the quickest but wrong route to get an answer.

because
1. this project isn't for me
2. the people that i'm working for aren't even aware of what are tables
3. they specified the use of access despite they don't know how to use it
4. they wanted this project finished for today at 9 a.m.

that's why i choosed that way to make the things
if i had more time i would work with multiple tables, but thats not the case sadly

[accesstos]

Hi all!

because
1. this project isn't for me
2. the people that i'm working for aren't even aware of what are tables
3. they specified the use of access despite they don't know how to use it
4. they wanted this project finished for today at 9 a.m.

that's why i choosed that way to make the things
if i had more time i would work with multiple tables, but thats not the case sadly

@Solymandias
Take a look in attachment to get some ideas for your next version (using mutiple tables).
You have to put the appropriate fields into the corresponding tables and forms. The popup form (sfrmReqs), while is open, stays synchronized as you make changes in main form (change record or TipodeTramite).

Good luck with your project!