Allow edits in Split Form

[Petros]

Hi all,

i would appriciate some advice in the following issue.

Split Form A is based on a query. back end on SQL. I choose to make the split form editable..the user can edit in the "single form" part. There is code running in the "on current" event of the form in order to synchronise a number of combo boxes. However, my sollution does not seem to function well, code stop running, simple commands executing form operations are stopping from running etc etc..

1. Would it be better to simply select the record..and further navigate to an single view form for edtis?

Any other ideas?

Thanks!

 

[Galaxiom]

A growing number of developers here are coming to the conclusion that the support for VBA in Split Forms is limited.

http://www.access-programmers.co.uk/forums/showthread.php?t=201587

Better to use a subform construction.

 

[Petros]

Thanks you for the tip..

I have also encountered the limitations of a Split Form, but as in all stories there are two sides of the coin ..if i proceed witht he form/subform prinicple..how can i incorporate the fantastic feature of expanding the Singel View tile of the Split form in a bounded form/subform,,from an end user perspective this is one of the most appriciated features of the Split form...

In my case i use the split form to display all "cases" that are due "today"..the user simple clicks on the record selector and can read all content of the form..as the number of records decreases he/she can simply expand the single view tile thus maximising the usage of one monitor..But that is also my point..if you wish the user to be able to edit complex records..it falls appart...most probably becuase of my incompetence more then the limiations of the Split Form.. ..so i choose something i can deal with instead..

Thanks!

 

[Galaxiom]

if i proceed witht he form/subform prinicple..how can i incorporate the fantastic feature of expanding the Singel View tile of the Split form in a bounded form/subform

It is difficult to be totally clear without actually having a sample of the database.

If I understand your requirement, this could be done completely automatically in VBA using some event that is triggered after the record is processed. The user would not even have to manually move the splitter bar.

The code would count the number of remaining records in the datasheet pane and calculate the space required to dispay them. If smaller than a minimum it would reduce the height of the subformcontrol that displays them and increase the space available to the subform that displays the "single tile".

The properties that control the vertical position and height of a subformcontrol are Top and Height. The RowHeight property of the form sets the datasheet record height.

These properties are measured in twips when working in VBA. A twip is a 20th fraction of a typographical point (72nd of an inch) making 1440 twips to an inch (567 twips to a centimetre).

However RowHeight defaults to -1 which means automatic and is rendered at 125% of the text height. The is calculated as the RowHeight property value (Twips) is 25 times the DatasheetFontHeight property (Points).

 

[Petros]

This is very valuble information Galax..i iwll clean up a database and see if i can post it..

Thanks a lot for all help!