mainform and subform on split

[pikoy]

I have a split form, mainform on top set to "data entry = Yes" and subform set to "data entry = no". however, they both display blank on load.

Is there a way to set it where the maintop form opens blank with the subform displaying data?

Thanks again.

 

[pikoy]

Thanks Pat. Will try that out.

 

[gemma-the-husky]

assuming the subform depends on the main form, then how could you have the main form blank, but not the subform?

the main reason for forms being blank blank (ie, not seeing controls that should be there) is if there is no data to display, and you are not able to add new records -either because the dataset is not updateable, or because you disallowed additions.

then you get this strange effect.

 

[Galaxiom]

Split Forms suck and should be avoided by any serious developer.

The pseudo-Datasheet and pseudo-SingleFormorm components cannot be addressed separately. These and other limititations generally become apparent after considerable effort has been expended and there are no solutions except redesigning it with subforms.

 

[Galaxiom]

I prefer to implement this with TWO subforms on an unbound main form. One subform shows a list and the other subform shows the details for the item selected in the list form. You'll need some code in the Current event of the list subform to requery the detail subform to show the selected record.

This can be done without code.

Place a textbox (or set of textboxes) on the mainform with a ControlSource as the appropriate field on the datasheet subform. This textbox then tracks the current record from the datasheet.

Then use this textbox as the LinkMasterField property of the subformcontrol that holds the SingleForm. The subform tracks record defined by the textbox/es.