>I'm back to my Visual FoxPro project after a long delai so I'm a bit rusty! My form has a grid and a textbox. When data RecordSourceType of grid is "alias" and ControlSource of textbox is "myfieldname", they are automatically synchronized. How can I filter the content of the grid and still have my textbox synchronized? I tried to change RecordSourceType of the grid to SQL-Statement and put my statement in RecordSource. It shows what I want in the grid but the textbox always point to the first record of the source table not to the result of my query.
>Thanks in advance.
>
>Claude
When the recordsource of a grid is an SQL statement, the result cursor is not available outside the grid. I recommend that you change the RecordSourceType back to alias, and then, in form.load, create the cursor with your SQL statement. YOu can then bind the textbox to the appropriate field in the cursor.
Erik Moore
Clientelligence