>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.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons