Adding subforms on a main form

[ludovic_44]

Hi All,

Im quite new to access , i have created a main form as attached where we have several buttons on the left and a subform in the middle on its right.
I want to display a subform based on the button click, i have already created all the forms , but i dont know how to display the subform individually in the main form by clicking on the button on the right, i really have to know it because of a project which im planning to do.



Your help will be highly appreciated


Thanks for your prompt answer guys as i'm really in great trouble

Ludovic

[pbaldy]

Your code would set the source object property of the subform control to the desired form.

[ludovic_44]

@pbaldy:
can you please tell me the code, realy i dont know the code. thanks for your reply
i have just create the for without even knowing how to proceed to do this, well i just hope this can be done now

Ludovic

[pbaldy]

Me.SubformControlName.SourceObject = "FormName"

[pbaldy]

I deleted your duplicate thread. Please don't post the same question twice.

[ludovic_44]

Im sorry guys,
I inserted this : Private Sub Command47_Click()
Me.frmDevelopment.Form = frmDevelopment
End Sub

@pbaldy told me to use the below syntax:
" Me.SubformControlName.SourceObject = "FormName"
i replaced SubformControlName by the name of the form which is "frmDevelopment"
and SourceObject as "Form"

I that the way of doing this please

[pbaldy]

Leave SourceObject alone, and put the form name in quotes, like I had it.

[ludovic_44]

@Pbaldy:
It works for the 1st button only when i applied same for the remaining it does not work, it shows an error:
Compile Error
Method or Data member not found

Please help me, im near! i have drag only one form as subform on the main form.
Do you think thats why i cant apply it for the remaining

Ludovic

[pbaldy]

No, you should be able to use a different form name for each button.

[ludovic_44]

Thanks very much
Thats what i did, but it does not work for the others.
When i drag a form ton my Main form as Subform, the name of the subform is the same as one of my form.(frmdevelopment)
and i have 15 more begins by frm and followed by the button name i have inserted as attached.

Do you think that this may cause an issue

[ludovic_44]

test1.zip

I have zip it as attached, please can you have a look, thanks for your kind help

Ludovic

[Bob Fitz]

Can you post a copy in A2003 mdb format.

[June7]

Do not understand this db. You have about a dozen identical forms structured like the one on the right, the only difference between them is a label at top. There is no code behind these forms and they are unbound. There aren't even tables to go with the forms. It appears you have 'jumped the gun' to building forms before the data structure is even set up.

A subform/subreport is created by installing a subform/subreport container control on another form. The container SourceObject can be table, query, form, report. It is a good idea to name container different from the object it holds, like ctrWorkshops. Your container is named frmDevelopment (also have a form by that name) and at present it holds a form named frmBreakDown. Why is BreakDown not in the list on the left?

You want to use code behind the buttons to change the container SourceObject. The code behind each button will have an expression like:

Me.frmDevelopment.SourceObject = "whichever form name you want to show in the container"

The code does work.

[ludovic_44]

Hi June 7,

Wow, im impressed because you have really analyse the DB , yeah i created this form without any code as you can see, and all the button in the subform in the left are the same except the label in the top is different, because i have not yet add the proper button and label in each of th form,
Would you please Sir, to modify it for me so that i can deeply understand the container and the parent and the form to be created, then i can work it in my level,
Because i badly need it and i dont know how to input the code and let it works

I want that the subform appears in the main form when i clicked the button on the left,
The frm breakdown is the same as Mobile Service, instead of inserting Breakdown, i have written mobile service

Thanks for your great help, i think your help wll really relieves me

Please

Ludovic

[June7]

No, I do not want to do this work for you. You already have code in place for two buttons. Just fix the form name for each as described in my post and uncomment the line in one of them. Then create the similar code behind the other buttons. All I did in your db was fix the code for the two buttons and it worked. This is a simple fix you should be able to accomplish. Even without edits, did not get error message.