>Can anyone give tell me what is happening in this case.
>
>History :
>We have a FoxPro 6.0 front end of SQl 7.0
>
>We modless forms.
>
>we go into one form and access a child table to see if the code entered by the user on this form is found in the child table.
>
>If it is not found we display a message.
>
>The user may proceed to the form that cause the not found and add the code required.
>
>The user then makes the first window active and them types the code in that caused the fault the fisrt time. The code doesn't show up.
>
>The only way the code shows up is if we exit the form and come back in.
>
>We are doing a select statement on the table. I am making the assumption that the sql statement picks the info from the server database and returns the information. As the above shows this may not be true.
>
>Can anyone help????
>
>TIA
>Shawn

Sounds like a refresh problem.

Are you using SQL pass through?