Hi Bruce,
grid appears blank.
>
>Well, some progress :) Put quotes around the lcValue, like this:
>
>lcValue = "IIF(lbValue,'N','Y')"
>
Same result... - blank grid.
>> 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?
>
>To define focus, first set the tab order, so that the first tabindex control will get the first focus. After that, you can maneuver the focus in code by doing in, for example, controlA Lostfocus:
>
>nodefault
>thisform.controlB.setfocus
You misunderstood what I want. I want to know the name of object which have focus before I do something. It could be any object of my form, I just want to know, which one.
In my mind I already created something - I can add Property - "PrevFocus" and assign this property
PrevFocus=this.name in each control LostFocus event ?
So, in this case I can do on my navigation bar controls LostFocus event
thisform.&PrevFocus..SetFocus() - right?
But may be here is better and simpler solution?
>>
>>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?
>
>thisform.grd2.setfocus && or whatever you name the grid
The grid2 was just an example. It could be grid1, grid3 or another object. I just want to know which one.
Thanks
If it's not broken, fix it until it is.
My Blog