Solved Same Table but different design subforms

[ZKHADI]

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

 

[theDBguy]

Take advantage of the linked master and child fields. Are you not using them now?

 

[ZKHADI]

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

 

[theDBguy]

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]

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

 

[theDBguy]

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]

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]

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.

 

[ZKHADI]

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 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.

 

[ZKHADI]

Hi. Sorry for the delay. See if this is what you meant.

Thank you from bottom of my heart. lOve you bro

 

[theDBguy]

Thank you from bottom of my heart. lOve you bro

You're welcome. Glad we could assist. Good luck with your project.