Hi Folks
Thanks for your replies.
I got the issue sorted out..the Requery() seemed to sort it out
Regards,
Gerard
>Try
>
>Select Code from Mytable where Type == Thisform.MyField.Value into Cursor MyCursor
>
>
>>I have a combo box with Sql command as source
>>This works fine:
>>Select Code from Mytable where Type = 'ABC' into Cursor MyCursor
>>
>>However, if the where is taken from another field on the screen as in
>>Select Code from Mytable where Type = Thisform.MyField.Value into Cursor MyCursor
>> nothing is selected even though MyField.Value contains 'ABC'
>>
>>Anybody got any ideas ?
>>Regards,
>>Gerard