SetValue Access 2002

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SetValue in sub-form macro 5
Unable to use Setvalue 1
SetValue and CurrentUser() 2
setvalue action changes record focus 5
How to setvalue of comboboxes to null 1
setvalue question 2
setting the argument in SETVALUE Action of macro 6
SetValue in Access 2007 2

Top