Split Form doesnt work with Navigation Form

Question

Hi,

Im trying to use the new Navigation Form mode, and one of my form using split mode doesnt want to show split. Using the that form alone, shows the split mode ok, but as soon as i try to move it into a Navigation Form, the split mode stop working. Ive passed 3-4 hours trying to play with the settings, but best i could do, is to put the Navigation Form into split mode, but even then doesnt work correctly, looks it only wants to show the split form into form view, the datasheet view, doesnt want to kick in. In the property of the Navigation Form, split mode is activated, allow datasheet view to yes, and the split form printing to datasheet only. Also, split the Naviagation Form was not my main goal, i just wanted to have 1 splited form, but was never able to make the split kicking in, playing on the propertys of that form. Not that i should have done anything, it should just have copy my original form, that is splited, into Navigation Form, on first try.

Answer 1

Hi RiverHunter,

Unfortunately, split forms will not work on subforms and will only show one view. So when you place the split form onto the Navigation form, it is treated as a subform, thus it doesn’t work.

Best Regards,

Nathan Ost

Microsoft Online Community Support

---

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

There is a work around, but it will open the form that is split as a separate form. You will need to go back to the Navigation form for other navigation. The work around is to create a macro to open the table in question. (Save it and make sure it works as you want it to.)

Go back to the Navigation form and the property sheet for the button you want to open the form. Under the DATA tab, make sure there is not anything listed for NAVIGATION TARGET NAME.  Under the EVENTS tab, ON CLICK, use the drop down to add the macro you created. Save the form...

1.  Create Macro

2.  Add macro to EVENTS - ON CLICK

3. Remember this form is independent of the Navigation Form.

Hope this is helpful to some until they fix this ... otherwise, just create a navigation form from scratch.

Answer 3

I know almost nothing about Access, but it seems to me that what is needed is to create a subform that is NOT linked to the main form, but passes a key value to the main form when it is clicked.  Because they are NOT linked, the subform will show all the records, not just the one in the main form, and then when you click one of the records in the subform, the click event would trigger a procedure to pass the key value to the main form, which would use that key value as a filter.

Unfortunately, because I know so little about Access, I don't know how to do this, but it seems pretty simple.  If anyone can give a code example, it would be greatly appreciated.

Answer 4

You are right. It will be awesome, I don't know why they don't allow it.

Answer 5

Is it just me, or does this seem silly?  Seeing a split form within the Navigator would be awesome.  Nathan, perhaps there is a workaround?