Ulises,
If your three tables are linked with "Set Relation", changing the order may have upset the relationships. Check the raw data before and after the order change to see if the tables are there and linked correctly.

You may want to consider using a cursor and reordering it as needed, also.

HTH
Barbara

>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