>I know this can be done, i have tried all sorts of stuff to no success.
>
>I have a text box that does which the user types in and it does an incremental search and performs an sql select into a cursor based on whats typed. I can browse that cursor and all is well. I can't seem to get the cursor to be displayed inside the grid so the user can see what is there based upon the input.
One easy way to accomplish this is just set the grid.recordsource = '' (empty string), do the SQL, set the recordsource to cursor:
grid.recordsource = 'mycursor'
then
grid.refresh and/or grid.setfocus
depending on what you're doing.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.