Hi, Colin. Couldn't you set the controlsource to the trainercode.id (or whatever)? Why, may I ask, are you leaving the controlSource blank? (This is for my own education <s>)

>I have a combobox on a form that has ControlSource=(None), RowSourceType=Fields and RowSource=Trainer.Lname,Fname,Position. In the combos Init I have the following:
>
>THIS.Value=Trainer.Lname
>THIS.DisplayValue=Trainer.Lname
>
>The Valid of the Combo REPLACES the current tables Trainercode and updates the .Value of 2 textboxes with Fname and Position. This is so the user sees Lname, Fname and Position on the form and in the picklist but only the code is stored to the table. This works fine.
>
>Now I want to do the same thing in a grid. However, if I set the ControlSource=(None) for the column the combobox is in, the default behaviour of the grid is that the column displays the next available undisplayed field of the grid’s record source.