Solved nagivation control. where clause = new record (1 Viewer)

[TipsyWolf]

Hi. I entered RiskID=0, and it worked for me. I'll send an image or reupload your db later.

Sent from phone...

very wierd ) db would be perfect. i haven't done any changes yet, so i would just continiue working on it

 

[theDBguy]

very wierd ) db would be perfect. i haven't done any changes yet, so i would just continiue working on it

Here you go...

 

[TipsyWolf]

Here you go...

before

after

yeah, it starts with new, but its a master list - i mean its wrong botton

i was asking about 2nd botton. 2nd botton means (New Risk) new records where user input data.

1st botton is MasterList - it should just open all risks in the list

but thank your anyway for your time

 

[theDBguy]

yeah, it starts with new, but its a master list - i mean its wrong botton

i was asking about 2nd botton. 2nd botton means (New Risk) new records where user input data.

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

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.

 

[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.