SubForms in access main form

[TskcAccessdev]

Hello to all
I want some solution...
Actually I have one form
In that top having combo box having field 11,12,13,14,15,16
In that below combo box I have six different subforms


Like child11,child12....,chield16
If I select 11 in combo box then child11 sub form will open
How to solve this one
Please guide me

[aytee111]

In the AfterUpdate event of the combobox:

    Dim x As Integer
    For x = 11 To 16
        Me("child" & x).Visible = False
    Next
    
    Me("child" & CInt(Me!ComboBox)).Visible = True

[TskcAccessdev]

Thanks for replying
Due to busy schedule I will try later
If u don't mind could you provide same logic by using if condition

[aytee111]

What condition are you looking for?

[TskcAccessdev]

Means if (combo box= 11) then
Docmd.open sub form like child 11
Else
If(combobox=12) then
Docmd.open sub form like child12
I need this type of code if possible

[TskcAccessdev]

I don't know which code exactly to use for docmd.?

[aytee111]

Subforms are not opened, they are displayed as objects on a main form.

[TskcAccessdev]

Yaaaa, but my problem is only particular inform will display that enable to edit other subform will ideal means not clickable

[aytee111]

Sorry, don't understand that sentence.

[TskcAccessdev]

If we work on one subform(selecting on 11 in combo box) then particular subform child11 is editable remain all 5 subforms are not clickable and not editable

[aytee111]

Not sure I get what you are trying to do - you still want the subforms to be displayed but no changes allowed? Change the code "Visible=True" to "Locked=False" and vice versa.

[TskcAccessdev]

Thanks brooo
Superb working above code
But the problem is intial form loading all 6 subforms displaying if I select on combo field only particular inform will displaying this is good but intial 6 form will not display on intial loading after selection on combo then subform will display

[aytee111]

In form design, set the properties on the subforms in the way that you want it to be when the form opens.

[TskcAccessdev]

If u don't mind could you tell me the process
In On load option I put docmd . Maximum for full screen
Where I need to see prority..
If u don't mine could you tell me the code
And where I need insert that one

[aytee111]

You do not need code for this. Set the properties in form design.