My database has a separate search layout. When people come to this screen, they select a preset date from a drop-down menu, then click a Begin Search button which puts the user in find mode. This button also puts the date selected from the drop-down menu into the Date field. They can enter other criteria before selecting the Continue button.

Problem: when users first come to this search layout, the results of previous searches are still displayed. While the Begin Search button will clear the fields once clicked, is there a way of removing any previous found records so as not to confuse users. In effect, I am looking for a "clear found records" script that can be put into the button that initially takes them to the search screen.

Any help appreciated!

Frank Bugeja

Hi, Frank. I assume you have a script that takes the user to the "separate search layout." Would you have anything against adding a step to this script to Enter Find Mode?

HTH,

Jerry

No, I wouldn't!

The situation is this. If I had the drop-down menu and the Begin Search button on one layout (by themselves) and clicking the Begin Search button went to another layout in find mode (and this layout had the search fields), then no problem - I wouldn't have the problem of seeing previously found records. They would be, so to speak, "removed" when I went to the second layout after clicking the Begin Search btn. BUT, wouldn't it be nice to be able to do what I what on one layout - w/out seeing previously found records to confuse the users of my database!

I would be very interested in seeing your script solution, Jerry!

Frank B

Take a look at the Script Step "Clear" and see if it doesn't do what you want.

Lee

Thanks Lee!

Unfortunately, the Clear command didn't work ...

I'm not giving up!

Frank

I'd echo Lee's comment. The only proposal i had was just what i wrote, add "Enter Find Mode" as the last step. Nothing more complicated.

You would need a separate "Clear" step for each field.

What did or didn't the Script Step "Clear" do.

Post your script if you can't make it work, and maybe we can spot the problem.

Lee

I've sent the file.

Login: password + username are both "abc"

Click red "Pastoral Concerns" button

Click "Search Pastoral Concerns button" (Uses script Go_To_Layout[search Pastoral (Infringements)]

As you can see, when you get to the search screen, you can see the details of a previously found student. If I select the date from the drop-down menu, then click the Enter Search Mode btn, it goes into find mode and the previously found record(s) disappear - but I was hoping that when you get to to this screen, any found records would not be seen.

Lee, I did try using the Clear command, one for each field on the search screen I wanted cleared, in the Go_To_Layout[search Pastoral (Infringements) script - but fields were not cleared.

Again, thanks for your help

Frank

Post deleted by Frank Bugeja

Post deleted by Frank Bugeja

Hi, Frank. Strictly speaking,

Click "Search Pastoral Concerns button" (Uses script Go_To_Layout[search Pastoral (Infringements)]

is not true. That button is not using a script.

Create a script with the following steps:

Go to layout ["Search Pastoral Infringements"]

Enter find mode

BTW, you should immediately take that attached file off the website and repost a clone, unless you want everyone in the world to know Emma A****'s disciplinary record. I don't know if the discussion of the Sarbanes-Oxley act elsewhere on this forum would have any relevance to this, but i wouldn't risk it.

J

Sorry for the delay in replying, but the time diffs between Aussie & US times, my experimenting with your ideas,.... Here is what I've come up with.

I've enclosed the same file (minus the real people in it!) to explain where I'm at.

Login & password: "abc"

1. Click red "Pastoral Concerns" btn

2. Click "Search Pastoral Concerns" btn (uses script GTS)

You go directly to the search screen and all previously found records are removed - but the Select Date drop-down menu is locked and no selection can be made from it, even though other drop-down menus in find mode work properly. I suspect the reason for the locking up of the Date Select drop down menu is that the values from this field need to be used in the Date field - and this is not happening!

Again, thanks for any ideas in getting the search layout working properly!

Frank

TRIAL.zip

gSearchDate is a global, and cannot be searched on. You should replace this field on the layout with whatever field holds the actual date information you want to search.