GoToRecord Command

[Guest]

I have a database for writing work orders and I need to send the work order
(on the form) to another employee who then retrieves the record, edits it,
then sends it along to another employee. It's a multi-staged routing process
that eventually gets finished by the person who actually does the work.

Anyway, Using the "SendObject" macro works fine but I want the person who is
retrieving the record to be able to view it on the form for easy editing.
When I try to use the "GoToRecord" I haven't been able to force the proper
record to come up in form view. I have a field named "Work_Order_Number"
that is an AutoNumber which I'm trying to use as the record to go to. What
am I doing wrong?

 

[Steve Schapel]

Ridnaway,

The GoToRecord action does not give the option to identify the record
according to data. One option would be an OpenForm action, and then use
the Where Condition argument of the OpenForm action to specify the
WOrk_Order_Number. Another approach that might be applicable is the
FindRecord action. Have a look at these two macro actions. It depends
a bit how the person trying to retrieve the record will be using the
Work_Order_Number.