Solved nagivation control. where clause = new record

[TipsyWolf]

Oops, sorry. When you said "2nd button," I counted them like this:

View attachment 113502

In that case, you don't even need to use the Where Clause at all. Try the attached now and let us know if it's what you want.

u r genius !!!
thank u very much !!!!!!!!!!!1

 

[theDBguy]

u r genius !!!
thank u very much !!!!!!!!!!!1

We're all happy we could assist. Good luck with your project.