A
Alejandro
I have a form based on an usertable to manage resources assigned to users. I
must be able to edit two date fields and a memo field. The resources are in
two other tables and linked with a IDresource field in a UnionQuery.
Since a recordset based on both tables can not be updated I based the form
on the table with users. The resources are shown by a multi column combobox
with all the resource data, linked by the IDresource field.
Is there a way to sort the data by a field in the combobox (the resource
category) rather then the underlying recordset? The only method I know is to
include this field in the recordset but this would make the recordset not
editable.
Please advise.
must be able to edit two date fields and a memo field. The resources are in
two other tables and linked with a IDresource field in a UnionQuery.
Since a recordset based on both tables can not be updated I based the form
on the table with users. The resources are shown by a multi column combobox
with all the resource data, linked by the IDresource field.
Is there a way to sort the data by a field in the combobox (the resource
category) rather then the underlying recordset? The only method I know is to
include this field in the recordset but this would make the recordset not
editable.
Please advise.