I have a table with FirstName, LastName, address fields, etc.

On my layout, in addition to these fields, I have a pop-up populated by a value list of all the LastNames.

Next to this pop-up I have a button labeled "GO".

Once the user has chosen the last name from the pop-up for the record they want to navigate to, I would like the GO button to take them there.

Is there some simple script that I can attach to the GO button to do this? I know how to attach a script to the button to go to next/go to previous, but how do I go to the record where "LastName" = the name the user has chosen from the pop-up? THANKS.

Hi, MarkSL C! Why you dint want using Find?

Look attachment!

aaa.zip

this is what you have to do if you want to use a pop up

i'm assuming its a dialog box

so you would have to have a script to bring up the pop up then on the next one or next step you have to put in

if

get(lastmessagechoice)= 1

preformscript [go]

else

exit script

end if

Major props to you aaa! Thanks for coming up with the db file for me to download and inspect.

My main problem is now solved ... although when I got to thinking ... it would be nice to be able to go to the new record as soon as the choice is made from the pop-up--without having to click the Go button.

Is possible?

Hi, Mark! In attacment you will see solving without button clicking.

aaa.zip

Edited October 28, 200520 yr by Guest

Wow. Works great. I could never have come up with that. Thank you. (I have a lot to learn with scripting...)