hi naomi,

The way we do this, is to requery the combobox in the when event. we populate the combos with an array that is a property on the combo itself


walter



>Hi everybody,
>
>I can use some help as what I've tried so far is all not working and producing error. I attached a picture demonstrating what I want.
>
>The grid's RecordSource is 'rsHolds' table. In this table I have LevelID, SectionID, Row fields and each of them I want to pick up from the combobox.
>
>Level restricts section selections and section dictates available rows.
>
>Here is the code in the Init of the form I tried:
>

>WITH thisform.grdHolds 
>  for each loColumn in .columns
>   
>      for each loControl in m.loColumn.controls
>         if upper(m.loControl.baseclass) = "HEADER"
>            loControl.Alignment = 2 
>            loControl.FontBold = .t.
>            bindevent(m.loControl,"Click",thisform,"HeaderClick")
>           
>         endif
>      next
>   next
>
>   with .colLevels.cboLevels
>      .rowsource = ''
>      .rowsourcetype = 3  
>      .rowsource = "select * from csrAllLevels where LevelID IS NOT NULL order by Descrip into cursor csrBLvls nofilter"
>      
>      .parent.ControlSource = 'rsHolds.LevelID'
>   endwith
>
>   with .colSections.cboSections
>      .rowsource = ''
>      .rowsourcetype = 3
>      .rowsource = "select * from csrAllSections where LevelID = ?m.nLevelID order by Descrip into cursor csrSect nofilter"
>	  .parent.ControlSource = 'rsHolds.SectionID'
>   endwith
>
> with .colRow.cboRows
>      .rowsource = ''
>      .rowsourcetype = 3
>      .rowsource = "select * from csrAllRows where LevelID = ?m.nLevelID and SectionID = ?m.nSectionID order by Row into cursor csrRows nofilter"
>      .parent.ControlSource = 'rsHolds.Row'
>   endwith
>
>*   .setall('DynamicFontStrikeThru','thisform.RefreshHoldsGrid()')
>   .refresh()
>endwith

>
>So, the grid does initially display. But as soon as I try to select anything in the combos, I start receiving messages about thisform is only available in a method and lots of other nasty errors.
>
>I'm not sure how to make this work.
>
>Thaks in advance.