Splitform or Form?

[calvinle]

Hi,

Just to know. I want a form that looks like a splitform, which mean the table datasheet is on top and the field textbox are on bottom.

Is it better to create a splitform and work from there?
Is it better to create a form, then add a subform datasheet, then add textbox on the main form?

Which one would you use?

Thanks.

 

[Galaxiom]

If you plan to use automation then build it with forms. Split forms have some gaps in addressing their object model.

 

[JLCantara]

Galaxiom: what automation has to do with form/subform design?

I always use the form/subform design because they are natural: invoice/items, etc.

 

[Galaxiom]

A Split Form is an easy wizard driven way to have a datasheet showing a bunch of records with a single form under it for editing all coming from the same RecordSource. It isn't for combinations like Invoice/Items which would have different RecordSources.

However the components of the split form are not individually addressable to the extent that can be done with a normal form/subform structure.