Solved Same Table but different design subforms (1 Viewer)

ZKHADI

Member
Local time
Today, 14:54
Joined
Apr 5, 2021
Messages
118
hy friends .....

i have one main form with 2 same table but different design subforms.
see in image highlighted 1 and 2 boxes.

one is deep details of fee and another is rows of multiple fee for student.
the problem is when i click the record selector of form 1. it is not goto that record in form 2.

how i can goto that fee details from table 1 to 2 by select record selector.
the both subforms control source is same
 

Attachments

  • Untitled.png
    Untitled.png
    110.4 KB · Views: 236

theDBguy

I’m here to help
Staff member
Local time
Today, 02:54
Joined
Oct 29, 2018
Messages
21,358
Take advantage of the linked master and child fields. Are you not using them now?
 
Last edited:

ZKHADI

Member
Local time
Today, 14:54
Joined
Apr 5, 2021
Messages
118
Take advantage of the linked master and child fields. Are you not using them now?
yes both forms are linked with main form as child and master. but the subforms are not working together
 
Last edited by a moderator:

theDBguy

I’m here to help
Staff member
Local time
Today, 02:54
Joined
Oct 29, 2018
Messages
21,358
yes both forms are linked with main form as child and master. but the subforms are not working together
If you want the two subforms to work together, you'll have to link them together. One way to do that is add an unbound Textbox to the main form that refers to the first subform and then link the second subform to it.
 

ZKHADI

Member
Local time
Today, 14:54
Joined
Apr 5, 2021
Messages
118
If you want the two subforms to work together, you'll have to link them together. One way to do that is add an unbound Textbox to the main form that refers to the first subform and then link the second subform to it.
i will attach here my file could you please do it i didnt understand what you are telling me
 

Attachments

  • kda college -working - Copy.zip
    1.5 MB · Views: 291

theDBguy

I’m here to help
Staff member
Local time
Today, 02:54
Joined
Oct 29, 2018
Messages
21,358
i will attach here my file could you please do it i didnt understand what you are telling me
I'm about to go to bed already and my computer is already shut down. If no one else does it by tomorrow, I'll do it then.

Sent from phone...
 

ZKHADI

Member
Local time
Today, 14:54
Joined
Apr 5, 2021
Messages
118
I'm about to go to bed already and my computer is already shut down. If no one else does it by tomorrow, I'll do it then.

Sent from phone...
i am not in hurry ... do it tomorrow pls. good night
 

Eugene-LS

Registered User.
Local time
Today, 12:54
Joined
Dec 7, 2018
Messages
481
i am not in hurry ... do it tomorrow pls. good night
Dear KHADI, always try to give sane names to form objects, it will be easier for you to navigate yourself.

I'm looking at your code ...
Option Explicit is there, but not everywhere
The code does not pass compilation :(
You need to be more careful, VBA is "high-level" language, but it also does not forgive gross mistakes.
 

Attachments

  • Screenshot 2022-03-07 115704.png
    Screenshot 2022-03-07 115704.png
    73.6 KB · Views: 222

ZKHADI

Member
Local time
Today, 14:54
Joined
Apr 5, 2021
Messages
118
t
Dear KHADI, always try to give sane names to form objects, it will be easier for you to navigate yourself.

I'm looking at your code ...
Option Explicit is there, but not everywhere
The code does not pass compilation :(
You need to be more careful, VBA is "high-level" language, but it also does not forgive gross mistakes.
thank you for your concern. but i have no issue with vba codes. i have different question which i asked above.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:54
Joined
Oct 29, 2018
Messages
21,358
i will attach here my file could you please do it i didnt understand what you are telling me
Hi. Sorry for the delay. See if this is what you meant.
 

Attachments

  • kda college -working - Copy (2).zip
    842.8 KB · Views: 294

Users who are viewing this thread

Top Bottom