Using "Splashscreen" Forms in Visual Foxpro

[nikdiva]

Hello Everyone,
I am currently attempting to refresh my knowledge of Visual Foxpro 6 after being away from programming in it for over a year (MS Access is my preferred RDBMS). I am trying to use a splashscreen where a user enters a search value and then selects what form it wants to go to using this criteria. I want the next screen to open showing data filtered by the user's input on the splashscreen. Could I do this using a query that prompts for input? Or some kind of global variable?

 

[chpicker]

Try looking in the help files for information on a Parameterized View. The other easy method is to use macro substitution in an SQL Select statement, like this:
[tt]
cMyFilter="myField='HELLO'"
SELECT * FROM myTable WHERE &cMyFilter ;
INTO CURSOR myTemp
[/tt]
Ian