>>>>>Could you send me this form ?
>>>>>Of course if there is no sensual information and no firm secrets :-)
>>>>
>>>>I seem to be now having problems when I add a new record to the grid (I have a button to add new row). I then go to combo level and try to pick up the Level. At this point I got an error about nLevelID is not found. Also, my selected value doesn't show up until I get out of the column.
>>>>
>>>>Do you see the same problems with your form?
>>>
>>>As far as I see- no.
>>>But I have one command button with these lines:
>>>
>>>APPEND BLANK IN crsMainGrid
>>>thisform.Grid1.Refresh()
>>>
>>
>>I have
>>
>>SELECT rsTSBlocks
>>APPEND BLANK
>>replace TemplateID WITH thisform.oCurrentNode.Values('TemplateID').Value
>>this.Parent.grdSeatBlocks.Refresh()
>>this.Parent.grdSeatBlocks.SetFocus()
>>
>>Do you see what may be a problem?
>
>Nope.
>O!!!!!!!
>Maybe ComboBox try to requery its source.
>
>Change WHERE clause in ComboBox rowsource:
>
>WHERE TheField = ?thisform.nLevelId INTO ...
>
>and make nLevelId to be a property of the form.
I may try that a bit later - removing SetFocus seems to solve the problem for now, but I made more changes and facing more problems at the moment.
If it's not broken, fix it until it is.
My Blog