>Here is the code.
>ThisForm.txtProcessDisplay.value = "Building road inventory records"
>ThisForm.txtProcessDisplay.refresh
>
>SELECT *
>FROM plc,lne;
>WHERE lne_placement_id = plc_placement_id ;
> AND lne_survey_id $ ThisForm.cSurveyString ;
> AND SUBSTR(lne_lane_number,1,1) $ 'RL' ;
> AND !lne_unable_to_rate ;
> AND !lne_unsafe_to_rate ;
>ORDER BY lne_placement_id, lne_lane_number;
>INTO TABLE data\pmi_inventory;
>DATABASE data\pmib;
>NAME pmi_inventory
>The textbox object is not refreshed until after the SQL statement finishes.
>I have tried both using a refresh on the textbox alone and the whole form.
>Same results, no refresh until after the SQL executes.
I assume you're not expecting Rushmore to optimize this puppy... (kidding)
To address your immediate problem, you might try copying Thisform.cSurveyString to a local variable and using that in the query. I don't know that it will do anything, but the reference to the form property in the query may be doing strange things internally. Besides, if you put the assignment in between the .Refresh() and the SELECT, that might fix the problem by itself.
I'd have other suggestions for this query, but you didn't ask for those, so I won't force them on you.