Hi All,

I love Richard's and John's NavF SubForm which Richard taught in Developer Lesson 49 Part 4.  I have modified slightly for 2 reasons which Richard thought 1, useful for all to see.  Images below of the code.

1. I had a problem where all buttons except the New Button worked.  The reason I found the code in NewBtn_Click() was (see image NewBtn_Click) and the Controls(0).SetFocus line.
It just happened that most of my Forms Control(0) is a Label.  You cannot SetFocus to a label.  With the help of ChatGPT I deleted that line and replaced with the 2nd image. This solved my problem with most of my forms.
2.  Now Richard said this lesson was a no vba code in the form iotself.  I have added one line of code in the form so NAVF is still a drop in subform where you can make one of the buttons invisible.  I hav e a number of forms where I don't want the user  to enter new records.  The user needs to just edit the record.  So image three shows the 1 line to make in my case the NewBtn invisible.  Image 3 and 4 the result.

Hope mthis helps some of  you.

Regards
Rdb, Geelong Australia