I would like to have a main form and various subforms.
by click a cmd buttom would like to have next subfrm to replaced previous etc.like frames
any ideas
thanks
Dennis

I am struggling with a topic that is related to this. I have created a command button on the main form that opens the required sub-form. On that sub-form, I added a control button that simply closes the form.

HTH

A nice looking way to do this is to create a form with tabs. Each tab page should hold one of the subforms. To make this work properly and keep everything in sync, the form with the tab control needs to be bound to the same recordsource as the main form so the master/child links will work.

Then place this new form as a subform on the main form. When the user wants to change subforms, he clicks the appropriate tab.

Another way is to draw one subform control on your form and call it ctlDisplay. You will find that you can change its .sourceobject property via code rendering tab controls pretty much obsolete.

e.g.

Private Sub ViewProjects_Click()

Me!ctlDisplay.sourceobject = "FormName"

end sub

Using a row of command buttons above ctlDisplay the user can choose which data they want to display in the window.



[This message has been edited by Jimbob (edited 04-19-2002).]

The bonus of not using tab controls is that you can format and colour your forms exactly how you want, without having to have a big ugly grey strip going through your form

Thanks to all.
I will look into it.
Will let you know how it turns out
Thanks
Dennis

I was able to add a cmd buttom and display my first subfrm,
But id does not link to the main frm
any ideas will be greatly appreciated
dennis