MSACCESS 2003 : How to use command buttons to display different subforms

[tarabztk]

MSACCESS 2003 : How to use command buttons to display different subforms

I have an application that display information about Pipelines and these pipelines have many other equipments attached to them like ‘Valves’, ‘Tanks’, ‘Pumps’, etc.

In this application I display using Access form, all details about a selected Pipeline. And I included in this form, a sub-form which display valves information by default.

What I would like to do is to create several buttons that once any one get clicked, will somehow replace the subform displayed and replace with another one subform. All subforms are have the same parent/child field link.

I tried to the change the SourceObject using OnClick events for the Buttons but no luck.

[barry07]

Seems to me the simplest solution is to stack the 3 forms one on top of the other, and make the required one visible when the button is clicked.

e.g

Private Sub Button2_Click()
subform1.visible=False
subform2.visible=True
subform3.visible=False
End sub

The code for the other bittons will be identical except that a different subform will have visible=True.

Set the default condition (I'm assuming this is subform1 visible) in the FormOpen event:

Private Sub Form_Load()
subform1.Visible = True
subform2.Visible = False
subform3.visible=False
End Sub

Hope this helps