Split Forms

[Eddie Mason]

I’m new to both the Navigation Forms & Split Forms in Access 2010, but I can see that there is a lot to be gained from their use. What I could do with is some advice as to whether a split form can run in a navigation form? From my experience when I linked a split form into a navigation form it rendered as a single data entry form, however it still continued to work properly as a split form when called from the navigation pane.

I would be grateful if someone could throw some light on this?

Kindest regards,

Eddie

 

[Eddie Mason]

My apologies to everyone before I wrote this enquiry I had not seen the correspondence on this and I did not realise that it could not be done. In my defence the video from Microsoft showing how to set up a Navigation Form shows a picture of at the beginning of a split form. I’m assuming at that time they believed that it would work.

Kindest regards

Eddie

 

[Galaxiom]

Forget Split Forms as they are beginner's rubbish. They don't work well with code. Use subforms to do the same thing.

 

[Eddie Mason]

Thank you for the advice, I’ve certainly wasted a lot of time on split forms. What I’m now attempting is to achieve the same by placing two unbound subforms onto a parent form; one subform as a continuous form and one as a single form. However what I’m still having difficulty with is synchronising the two forms that is getting the single form to refresh dynamically as I select a record in the continuous form.

Is there any advice you can give me on how I can get this to work?

Kind regards

Eddie

 

[Galaxiom]

Create a textbox on the main form with the ControlSource as the key field in the Continuous Form (=subformname.Form.fieldname or =subformname!fieldname).This textbox will automatically track the current record.

In the subformcontrol of the Single Subform set the LinkMasterFields to this textbox and the LinkChildFields to the key field. This form will now track the textbox.

Both fields must be in the recordset of the forms but the control is not required.

BTW It is possible for the LinkMasterFields to point directly to the field in the other subform but this is dependent on the order of the subforms loading and often fails. The textbox makes it reliable.

This textbox can be hidden but it is sometimes useful as current record indicator.

 

[Eddie Mason]

Many many thanks for your help; based on your advice the single form now tracks the continuous form. This is just what I wanted.

Kindest regards,

Eddie