open other forms as subform rather than seperate form on the basis on combo selection

[tariq nawaz]

i am a very novice user and just two weeks before start working on Access.
i am making some data input form.


i have a main form and then i have some connected forms with that..
on the basis of selection of combo box i can open the connected forms .
But i want the things that they should open in the main form on the right.
i have only two fields on main form and i want to populate rest from sub form.

this is the VB code how i can open connect the new forms on the basis of combo selection from main form.
"
Private Sub Service_AfterUpdate()
Dim strForm As String


If Me.Service = "Airsure" Then
strForm = "Airsure_input"
ElseIf Me.Service = "AirsureAdditionalCompensation" Then
strForm = "AirsureAdditionalCompensation_input"
ElseIf Me.Service = "BFPO_LargeLetter" Then
strForm = "BFPO_LL_input"


ElseIf Me.Service = "BFPO_Packet" Then
strForm = "BFPO_Packets_input"
ElseIf Me.Service = "e24Oversize" Then
strForm = "e24Oversize_input"
ElseIf Me.Service = "EmergencyUkTracked" Then
strForm = "EmergencyUkTracked_input"
ElseIf Me.Service = "RegisteredMail" Then
strForm = "RegisteredMail_input"
ElseIf Me.Service = "UKTracked" Then
strForm = "UKTracked_input"
ElseIf Me.Service = "UKTrackedPriority" Then
strForm = "UKTrackedPriority_input"
Else
strForm = "main"
End If


DoCmd.OpenForm strForm, , , "input= " & Me.Service
End Sub
"
i want the other forms to be shown in main form not opening as separate forms.

i want the strategy to populate all the details from all sub forms into a single table.
it will be highly appreciated if someone can guide me.

as i mentioned i am very novice user but help will be highly appreciated.

Regards

A learner

[pbaldy]

You can put an empty subreport control on the form and set its source object property in this code.

[tariq nawaz]

i am so thankful to this forum and specially pbaldy for his replies.

i cant have done what i have done so far without this forum and your help.

as i mentioned before as i am very new to forum and field i need some more guidance in some things.

i have attached the file what i am working on.

i need some detailed help of how to make it work according to my requirements.

i will appreciate your time and help and will be so thankful if you can come with some ideas.

1. i want all the output going into a single table which i can export finally in excel at some certain time like "6.00 PM".
2. i need to have certain conditions on certain services . the services are airsure , e24oversize , registered mail etc.
3. it will be great if you can give me ideas which i can make tables from start and doing VB coding.Actually i have done some VBA code already.

i want to make a very good application.i am working hard and putting my effort but as i said u i am novice so i have to work hard to learn and implement at same time.

Highly appreciated Baldy.As i am new to forum is there any way i can post something which mention you in blue referring you. i have no idea how to do that.

Regards

A learner

[pbaldy]

Happy to help, and your thanks are enough.

I don't really understand the questions. You can export a query that pulls together data from different tables. I have no idea what you mean by needing certain conditions on certain services.