Hi all:

I've been trying to solve this problem for 2 days and I just can't accomplish a thing :(

I have a form with a grid. The parent section comes from a suppliers table. If I select a supplier, this grid shows all the supplier's products. So far so good. The grid comes from two tables as I need information from two separate tables here. I'want an option group in the parent form that sorts the records in the grid by either one of two fields, depending on the value of the optiongroup.

I tried:

select prodsupplier
if optgroup.value=1
set order to suppliercode
else
setorder to ourcode
endif
thisform.refresh

or

thisform.mygrid.recordsource=""

and after sorting

thisform.mygrid.recordsource="prodsupplier"

In any case, the grid just goes blank and can't do anything else on that form. Any ideas?

Thanks for your time.

Ulises