Convertform to split form

[Mist]

I have a standard form containing many controls that I'd rather not have to redesign. In certain circumstances I would like the view to be that of a split form with the table's records scrolable and selectable. Can I convert/create a split form from my standard form? If so where do I start?

 

[PNGBill]

Do mean the difference between a Single form and Continuous form ?

If so, just go to the form properties and change from Single to Continuous.
Do this on a copy if you are not sure.
The controls can be moved around and place the general command buttons on the form Header and Footer with any Record specific buttons in the form Body.

 

[Pat Hartman]

You can't use the built in split form (which is limited anyway) with an existing form but you can create a new main form on which you add a subform in datasheet view and use that to "find" records to show on the original main form which will now be a subform on the new unbound form.

So you have an unbound main form with two bound subforms. One in DataSheet view and one in single form view.
Change the query that you use as the RecordSource for the single record form to have criteria that references PK field on the DS subform.
In the Current Event of the DS form add a Requery for the Single record subform.

Criteria in Single form RecordSource:
Where MyPK = Forms!frmMain!sfrmDS.Form!MyPK

Code in DS Current event:
Forms!frmMain!sfrmSingle.Form.Requery

 

[Galaxiom]

Forget the split form. They are rubbish for serious development because they have serious coding limitations.

Just add a subform for the extra bits you need or set the existing form as the SourceObject of a subformcontrol on a new form design.

 

[spikepl]

#3

You can't use the built in split form (which is limited anyway) with an existing form

why is that? My finished bound forms reappear quite happily, when Default View is changed to Split Form

#4

They are rubbish for serious development because they have serious coding limitations.

More specifically, if you have any coding experience (or need), you'll get used to and expect a given type of consistent behaviour from your forms. Split forms have a number of their own quirks that always emerge when you least expect them. For a simple pick-and-chose-a-record application* (and nothing else) I still use them (with data input in the dataseet part disallowed). For anything else, I use form/subform, or two subforms in a form, or form/listbox, because only then have I full control over what is happening.

*For experienced users. For anyone else, I have given up on fool-proofing the user interface in a split form because it is much too much effort, and use the other options.