>Hi
>
>I have a table with contains students reservations and this table has a field with contains the course
>code (there are several courses and more courses can be added )
>
> I would like to grab all course codes in a combo, and then use the combo
>to filter the records that show on the grid as a select a state on the combo
>
>Moises
The same result as select distinct code will also give you
select code from Reservations group by code into cursor cCodes
and then you can use this cursor as a RowSource for the combobox.
If it's not broken, fix it until it is.
My Blog