Hey everyone...first time poster here...so HI EVERYONE...hope you're having a great day!

Ok now for the reason for this post. I will try and describe the situation my best. One of the girls here is wanting me to create a button that when she clicks on it...it will do a search through a specific layout called Interview Schedule that is on the same databse...looking for whatever college she selected from the pull down menu to find available interview times for that college.

I am assuming that I should do this through a script...but I can not figure out how to make it pull from the Interview Schedule list only the selected college that she's chosen.

Anyone have a clue how to do this...or even better yet...understand what I'm saying? HAHA

I hope someone has an answer.

Thank you for your time,

Jami

What you need is conditional formatting and dynamic formatting.

Have a look on this web site nightwing I learnd what ever I can form the example on this site, Thanks to Cobaltsky.

You can also search the forums for conditional formatting and dynamic formatting

I'll assume you know how to make the pop-up list...

Create a global text field (called, say, gCollege) put it on your find layout and format it to display the pop-up list of colleges. Next to the pop-up list put a button that runs a script that does something like this:

Allow User Abort [off]

If [ IsEmpty(gCollege) ]

Beep

Show Message [ "Select a college from the list.", OK]

Go to Field [select, gCollege]

Else

Freeze Window

Enter Find Mode []

Set Field [ College, "=" & gCollege]

Perform Find []

End If

Don't select the option to restore find requests with the "Enter Find Mode" or "Perform Find" script steps.

After the Perform Find step you could add steps that change to a list layout to display the results of the find. You could also add steps that trap for find errors etc, but this is a good start.

Man you guys ROCK! Thank you so much for your help!