>I have a grid in my form and it has three columns, 1st & 3rd are for textboxes and the 2nd one is a combo box. I have set the combo box to a defectdesc table. In my combo box, I have set my RowSource = defectdesc.defectdesc and RowSourceType = 6-Fields. Also, I have set the Style = 2-Dropdown List.
>
>When I run my form, I get the defectid on the first column of my grid, and I get the combo box items on my third column which I did not need. This two columns are for user to enter the circuit code and failure mode respectively. Also, my 2nd column gives me an error saying Record is not locked. I also have the View property of the Grid set to 2-Change Browse.
>
>Please help.
>
>Thanks,
>Sam
Firstly you should specify grid.recordsource.
After that you should specify each column controlsource property, e.g.
Thisform.Grid.colUser='defect.user'
Also, I don't see why you touch View property.
Edward Pikman
Independent Consultant