Did you remember to set the recordsource (or is it rowsource?) for the grid? That one gets me more frequently than I'd like to admit. Then I put it in and it wipes out all my control sources, so I have to put those all back in again. Grids are annoying... :)

-Michelle



>Hi,
>
>I created a view with SQL. I didn't specify any properties with DBSETPROP and think this might be my problem, but read on. I filled out the control source for each column in the grid and I also used set to double check the view and make sure that it had the right info.
>I also double checked where I requeried and this seems to be ok also.
>My problem is, that even though the view appears to be correct and the control source of the grid is correct nothing shows up in the grid once I specify controls source for the columns. Can anyone tell me what properties I need to set with DBSETPROP for the view?
>
>Let me know,
>
>-Nathaniel