I have a request manager tool I am working on (and constantly improving) and within the tool I have a main table that captures all my requests and I have a second table that captures the asset and serial numbers of the device or devices for each individual request.  The device details are captured int he main form as a subform.

One of my reports concentrates on the asset details and the report is based on the device table, however what I want to be able to do is search for a specific asset or serial number and then, using a custom action I want to call a function that opens the request record for editing (using the request ID as the identifier).

I'm not sure how to go about starting this code so any guidance would be greatly appreciated.

Matt