Hmmmm....I still don't see why you couldn't use a view and the ORDER BY clause to put it in the order you want it and make it parameterized on document number. As to the original question, check your Column data settings and make sure that the controlsource is correct for each and that the Bound property is set true. Could be some weird foul-up between the Column settings and control settings.


>This particular grid is used in a pick a record type form. The locate button is pressed on the main form and then this grid will come up and allow the user to type in a document number. As they type then the grid positions them at the record. It is very slick and the user like to be able to see the document and revision history as they search throught this grid.
>
>So a view would not do as I would have to create this view and have it ready (indexed) everytime this screen comes up. The root table is 35,000 records and the master tables has 80,000 revisions/changes.
>
>Unless I am missing something.