Hi Bruce,

>> I still have the problem - now my grid appears blank. May be I need to forget about this idea? :)


>I mean, just dump the table into a test readonly grid, without any of the above code, and set a logical column controlsource as we discussed...it will work, I've done it many times...

Now it works for the test form, but still doesn't work for actual form - grid appears blank.

This is my new code:

if TYPE(lafieldlist[i])="L"
lbValue=&lafieldlist[i]
lcValue=IIF(lbValue,'N','Y')
This.columns(i).controlsource="''+lcValue"
else
This.columns(i).controlsource = lafieldlist[i] && Assign controlsource
endif


I have another unrelated problem. How can I define which control of my form has focus before I do something and how can I return focus on this object?

For example, I have form with 3 grids and navigation bar. I seat on second grid, then I click next button of my navigation bar. I want to return focus on second grid now. How can I do that?