>Try this:
>
>

>mFindRefNumber = 2111
>
>SELECT * from AA ;
> WHERE AA.Number = mFindRefNumber ;
> INTO CURSOR BBQ NOFILTER
>

>
>I was put INTO CURSOR clause at end of statement and also remove comma after NOFILTER.

Hi Plamen:

Thank you for your response. It still did not work. What I am doing is as follows. From Form Y i click the Find button. Brings up Form X.

1. Enter a name in a text box on Form X
2. Click Find.
3. Gird in Form X is populated with all names that are similar to one i entered.
4. Click event in the text of Grid1.column1,2 ... captures the name and number.
5. The number is stored in mFindRefNumber.
6. Dbl-click or clicking the Return command button returns me to the calling Form Y.
7. GotFocus Event of Form Y has the following code:
If mFindRefNumber <>0
Do the Select statement (the one I had posted)
Assign the values from the cursor to controlsources e.g
mClientNumber = BBQ.Number, so on.....for the rest of the fields

Problem: The select statement returns 0 in the cursor, i.e., nothing is selected.

Thanks.