Hello

I have made a database for an architecture practice's library. It only has one table and you simply click on the kind of book your looking for (e.g. windows/doors/stairs) and a list of all the related books shows. So it's a series of buttons and scripts. Pretty simple.

It seems to be running smoothly but have come across two things that could make it easier to use.

1. If nothing is entered in the search fields I want an error message to appear giving the options to modify their find as opposed to just showing all the results.

2. If a search returns no results I want an error message to appear giving the options to modify their find as opposed to just showing all the results again.

I've dabbled with some scripts and attached them to the find button with limited success so any help anyone can give would be greatly appreciated.

Thanks!

Prior to perform find, try a

loop,

exit loop if ( search_field not = "" ),

showmessage... ,

end loop,

perform find.

To catch the no record found, prior to the perform find

loop

...

Set Error Capture (On)

Perform find

exit loop If Get (found count) > 0

Show message "try again"

end loop