Oops, works great unless there aren't any records!

[Diana, Cda]

lol, well, got my db working beatutifully thanks to everyone's help. Just ran across a tiny, little, teeny-weenie glitch I must fix so that people can use it without a hitch <g>.

I'm glad that one of the layouts I have in the db hasn't anything entered into since it's new. All along I had just some dummy records I was using to test the scripting. When I was done just now with the filtering issue, I deleted all of them. I was then in the main layout that has 280 or so records and was trying to get back into the new layout when I was stopped by the "go to" not finding data according to the FIND criteria. So it will go to the new layout, but only after stopping the user with a "No records match this request" and the 3 "Modify Find", "Continue" and "Cancel" buttons.

What coding can I put in the "go to" so that it goes directly to the layout bypassing this problem when there are no records fitting the FIND criteria?

Thanks muchly for all the help!

[mun]

Try modifying your "go to" script with error capture. Turn error capture on at the beginning of the script and after the step where you open the database with no records (where your script usually fails) put:

if (status(CurrentError) = 0)

# your script steps to exit this script

else

# your script steps to go straight to the layout without a find

end if

I hope this helps you avoid those messages.

[Diana, Cda]

lol, this is _too_ funny. This worked great, but now, what the resolution did was bring me right back to my intial problem, that of how the records are brought up. The way I know how to incorporate this new script change, bypassed the necessary filtering when entering the layout via the "go to". Interesting!

I have chewed this over and over today and my brain is getting shortcircuited. Still too much of a newbie in many ways.

If I may, I'm attaching my db. I started typing out all the rigmarole, but it's too complicated an issue. Things sometimes work in some cases and not, in other.

Also, don't feel, anyone, that I need to be given the fish; you can teach me to fish as I'll learn better that way. If you can just take a look and let me know what best approach can be, that'd be great!

p.s., it's still very raw and I've changed things around so not everything is still working the same in the other layouts. I need to incorporate the new tabbed interface more.

The other aspect that doesn't work now is the show all records and show only found, since it's no longer _all_ the records I'm dealing now that there are two layouts and records shown depend on a FIND criteria. But that's another story.

Thanks everyone!

[Diana, Cda]

... attachment didn't take ...

Recipe Cataloguer Clone.zip

[Diana, Cda]

'kay, putting my recently learned print-to-file skills to use, here is the script that finds/sorts appropriate records per layout although I am only showing one script here.

Enter Browse Mode

Enter Find Mode [ Request 1: Source M ]

[ Restore find requests ]

Set Field [ Source, "M" ]

Perform Find [ Request 1: Source M ]

[ Restore find requests ]

Sort [ Sort Order: Recipe title (Ascending)Page # (Ascending)# on page (Ascending) ]

[ Restore sort order, No dialog ]

Go to Layout [ MISC ]

Toggle Window

[ Maximize ]

The way I tried to incporate the if (status(CurrentError) = 0) script above, only bypassed the necessary filtering in my own scripte. You can see this in action in the file I finally managed to attach correctly in my previous message just above.

Thanks and going offwhile for a little while to have a late lunch, but will return to see what you call determine. Cheers!

[mun]

Okay, after looking at this - what if you don't even include the if statements, just the "Set Error Capture [On]" step? It seems that this will see the error, but won't report on it and will get you straight to your layout.

Sorry to have put you back to square one with my suggestion.

[Diana, Cda]

Wow, wow, wow! That did the trick!

No worries about the other way, I learned something, and I'm always grateful for that.

I just can't believe how beautifully this is turning out. When I see what I started out with and where I am now, and it's all thanks to the help here mainly. I've never taken courses or anything in computers and it's just so awesome that I'll soon be able to finish this solution.

Anyway, thanks once again. It seems to be working a-okay!