>>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.