I've figured it out. The problem was that I was using the name of the text
box (time) instead of the data source for that text box (timescheduled).
Rather than
Forms![control]![worklist]![approved].Form.OrderBy =
"Forms![control]![worklist]![approved]![time]"
or the suggested
Forms![control]![worklist]![approved].Form.OrderBy = "[time]"
The answer was
Forms![control]![worklist]![approved].Form.OrderBy = "[timescheduled]"
vircalendar wrote:
Thanks for your input. Unfortunately, neither change worked. The first lead
to an inability to define the variable (program stopped execution and asked
me to define the variable Time) and the second change left me with the same
runtime error.
Perhaps the problem is actually in this line and the line where the error is
generated is caused by the value in the orderby property
[quoted text clipped - 22 lines]
End Sub
--
Message posted via
http://www.accessmonster.com