Subform question

[jackrobyn1]

Is it possible to have a form FRM1 as my main form and a way of choosing
which subform to view, i have 2 i would like to have as subforms, "Vehicles"
and "employees". In effect what i mean is one form FRm1 that has 2 buttons in
the form footer one that changes the viewed subform to employees, the other
button changes the viewed subform to vehicles.

 

[Rick Brandt]

Is it possible to have a form FRM1 as my main form and a way of
choosing which subform to view, i have 2 i would like to have as
subforms, "Vehicles" and "employees". In effect what i mean is one
form FRm1 that has 2 buttons in the form footer one that changes the
viewed subform to employees, the other button changes the viewed
subform to vehicles.

Either use one subform control and use your code to change its SourceObject
property or just use a TabControl with each TabPage containing a subform.

 

[Pieter Wijnen]

or have 2 subforms 1 visible & 1 not
& use code similar to this

Private sub cmdVehicle_Click()
me.employees.visible = false
me.vehicles.visible=true
end sub

HtH

Pieter