A
Alain Bourgeois
I would like to report one (more) bug in access 2007.
If you have a continuous read-only form based on a simple query. Form's
OrderBy is empty.
On this form I have a button. In the onClick Event, in a macro, I have
[Forms]![formname].[OrderBy]="[queryname]![FieldName]"
In all access versions, clicking the button sorts the records in the form on
FieldName.
In access 2007, setting the orderBy property is ignored if no OrderBy value
is present in the form.
To correct this, I had to set an orderBy property in the form then save it.
It works afterwards.
Will this problem be corrected in service pack 2? (otherwise I will have to
check ~150 forms where this problem could happen).
Regards,
Alain
If you have a continuous read-only form based on a simple query. Form's
OrderBy is empty.
On this form I have a button. In the onClick Event, in a macro, I have
[Forms]![formname].[OrderBy]="[queryname]![FieldName]"
In all access versions, clicking the button sorts the records in the form on
FieldName.
In access 2007, setting the orderBy property is ignored if no OrderBy value
is present in the form.
To correct this, I had to set an orderBy property in the form then save it.
It works afterwards.
Will this problem be corrected in service pack 2? (otherwise I will have to
check ~150 forms where this problem could happen).
Regards,
Alain