troubleshooting Question

Navigation on form, subform, sub-subforms

Avatar of Fred Fisher
Fred FisherFlag for United States of America asked on
Microsoft AccessGolang
2 Comments1 Solution130 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros