Record Navigation Bar in Navigation form.

[MichaelA]

If I open my forms, the record navigation bar shows all records and I can arrow through them. However, when I open my navigation form those same forms, within the navigation form, only show a new record. Why is this? Can it be corrected?

Thank you!

[moke123]

Have you checked if the forms are set to data entry?

[MichaelA]

Yes, both the navigation form and the subform are set to data entry.

Have you checked if the forms are set to data entry?

[June7]

Then set DataEntry property to No.

[MichaelA]

That didn't work either. I set data entry to no for both Navigation and Subform, and then tried Nav to yes and sub to no then the other way around.

Then set DataEntry property to No.

[June7]

Works for me.

If you want to provide db for analysis, follow instructions at bottom of my post.

[moke123]

Does the code to load the subform have any argument setting the form to data entry?
Many of us dont use the built in Nav forms. I find them to be quirky and a P.I.T.A. to reference controls and such. Much easier to build your own.

[MichaelA]

Sorry it took so long. I've been working OT.

EZGradebook.zip

Works for me.

If you want to provide db for analysis, follow instructions at bottom of my post.

[ssanfu]

A lot of the forms have code in the form load event:

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

You have told the form(s) to goto a new record. (June is correct - see next post. I mixed up code in another dB )


Forms "frmSchoolInfo", "frmGradeLevelEnrollment" and "frmCourseEnrollment" do NOT have the on load code.

Forms "frmStudents", "frmCreateNewCourse" and "frmCreateNewAssignments" has the on load code.

[June7]

Looking at EZ Gradebook Home form.
Forms have code that sets focus to new record.

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

If you don't want that behavior then remove the code.

And I see ssanfu already posted with similar info. However, does not set to Data Entry Mode. Can still navigate to existing records.

[MichaelA]

OK, help me understand, though. If I open the forms, when I'm not in the Navigation Form. They open to a new record but I'm able to navigate through other records. But, when I'm in the Navigation for, it doesn't work. I only see the new record.

Thank you!

A lot of the forms have code in the form load event:

Private Sub Form_Load()
   DoCmd.GoToRecord , , acNewRec
End Sub

You have told the form(s) to goto a new record. (June is correct - see next post. I mixed up code in another dB )


Forms "frmSchoolInfo", "frmGradeLevelEnrollment" and "frmCourseEnrollment" do NOT have the on load code.

Forms "frmStudents", "frmCreateNewCourse" and "frmCreateNewAssignments" has the on load code.

[ssanfu]

When I open your example dB, the school info form is displayed. I click on the STUDENT INFO button and the Enter New Student form is displayed.
I entered 3 more students.
I click on the School Info button and the school info form is displayed.
I then click on the STUDENT INFO button and the Enter New Student form is displayed and it is at "New Record".
If I click on the "First Record" button, the first record - William Bradford - is displayed.
If I click on the "Next Record" button I move to the next record (Jim Beam).

Is that not what is supposed to happen?

[MichaelA]

What happens when you close and reopen the db. Do the new records still show?

When I open your example dB, the school info form is displayed. I click on the STUDENT INFO button and the Enter New Student form is displayed.
I entered 3 more students.
I click on the School Info button and the school info form is displayed.
I then click on the STUDENT INFO button and the Enter New Student form is displayed and it is at "New Record".
If I click on the "First Record" button, the first record - William Bradford - is displayed.
If I click on the "Next Record" button I move to the next record (Jim Beam).

Is that not what is supposed to happen?

[ssanfu]

OK, I closed the dB, then opened it. Clicked on the STUDENT INFO button:


Form opened to a new record.

(Note the RED arrow and the red box.)
The dB you posted only had one student William Bradford, so I added 3 more students.
Click the first record button and it displays Bradford. Next record button moves to a different student.

I did not have to re-enter any students.......



I have never used the Nav form - I have always created my own forms. The Navigation form is too limiting and hard to reference.

[ssanfu]

I just looked at William Bradford's birth date - 3/19/1590.