SetValue Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to use SetValue in a macro to set the OrderBy property in a
report to the name of a field in the data source (a table)

I have opened the report in design mode and I am using the following in the
SetValue:

Item [OrderBy] the name of the report object property
Expression [Key] the name of the table input field I want to order the
report by

When I run the macro I get a message that it cannot find the name "Key"
entered in the expression.

Can someone help me with the proper syntax? Seems so simple but I have tried
every variation I can think of with no luck.
 
Back
Top