Drop in Nav Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Drop in Nav Subform

John Schreiber

6 months ago

I have a DB with a set of Forms 3 deep. So, the Form 1 shows a single record. Within in that form is a subform Form 2. This form can have several records bound to the single Form 1. Inside Form 2 is another form as a subform Form 3. Form 3 will only have 1 record per Form 2. I want to use Ricks Drop-In Navigation subform to cycle through all the Form 2 records. Where should I put the Nav sub-form, inside Form 2 or? And, since the only form that will cycle is Form 2 how would I refer the Parent Childe relationship. In the skim Form 1 is parent, form 2 is child and parent to form 3. And form 3 is only a child. If subform NAV is in Form 2 can I just refer to form 2 as a parent.I am trying to adapt Ricks Drop in Nav to work inside a Subform. Thanks

	Richard Rost @Reply 6 months ago
I am having a very difficult time trying to image in my brain what you've got going on there. Can you post some screenshots? Black out any sensitive data?

John Schreiber OP @Reply

6 months ago

OK here is the screen capture. This about Dog Showing. Blue area: Parent form Name of Dog Show only one record. Pink area is about the dog being shown. There can be multiple dogs shown at the same show, so this is where I want the drop in Nav to go as indicated in white of the screen show. Yellow area is the Dogs area subforum. It will show the results for each dog so only one for each dog. I have but text next to or in each aera. Yellow for blue parent, White for Dog Subform (some inside and some outside), and Black for the results for each dog - inside the yellow area. So, because I am dealing with 3 subforms do I need to change any of the code to only advance the Dog entered (pink) records.

	John Schreiber OP @Reply 6 months ago

	John Schreiber OP @Reply 6 months ago
Here is the picture with notes.

Richard Rost @Reply

6 months ago

Honestly, what I would do to make this easier is keep your show name as the blue parent form. Your red form for the dog entries I would make that a continuous form so you could see all of the dogs at once instead of relying on a navigation form. Then put that breed group and show results in a sub-form in the footer of the red form. That way you don't need a navigation box at all; you just scroll up and down through the dogs. This would actually make a pretty cool video, so I'll add it to the list. Do you mind if I share what you have here publicly in the video?

	John Schreiber OP @Reply 6 months ago
No, I don't mind at all. Thanks for the suggestion. I will give it a try. I will get back to you after I change it around.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View