asked on

Navigation on form, subform, sub-subforms

I have a complex problem. I have a main form (frmTitles) that holds the title (CD Title) information. On frmTitles there is a subform subfrmSongs (continuous form) and in the footer of subfrmSongs are two forms frmMMSongComposer and frmMMSongGroup which are both Many to Many Relationship to tblSongs (frmSongs).

I would like to enter the Title information, then the song information. This is where is gets dicey. The tab order for subfrmSongs is Side/Disc, Position, Song Title, Song Type and SongLength. Once I exit SongLength I would like to go to frmMMSongComposer, then frmMMSongGroup and then back to subfrmSongs to enter the next song.

As the form is now I have to enter each song, then for each song enter the information for frmMMSongComposer and frmMMSongGroup then select the next song.

Is there an easier way to structure this? Note in the attached
2018-10-06-MusicManagerRelationships.pdf

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Fred Fisher

ASKER

Since I will be the main person entering the info I agree totally. What I thinking is that when you exit SongLength (AfterUpdate Event) A YesNo dialog box with the message "Are you finished entering Song composers and Performers?" (default No) If No then a bookmark is placed in the subfrmSongs and then focus is set to enter Composers. Again after each entry in Composers a YesNo dialog (default No) "Are you finished entering Composers" when Yes is selected then the focus is then given to enter Perfomers, another YesNo dialog "Are you finished entering Performers?" again default No. When Yes then you retrieve the bookmark, move focus to the next song. This all repeats until after SongLength the user answers Yes and the forms are closed.

The table tblGroupSongs has the same function as tblComposers.