General information
Category:
Forms & Form designer
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only