Opening Specific Records in a Form (Form to Form) 1

[MattMeat]

Hello,

I have two forms that I am working with. One is a form in datasheet view, and the other is a WorkOrderEntry in form view. In the datasheet, there is a specific column called "WorkOrderNo". This column contains the numbers I would like to use to open the other form, with the correct record showing. Basically, I need the corresponding WorkorderEntry RECORD to open on double click of the number in datasheet view. I can already toggle between the two forms by using macros. I just can't get the correct corresponding record to come up. I would also like to know if there is a better way to go about solving this problem,

Thank You Very Much,
Matt

 

[James79]

Open the datasheet in the design view. right click on WorkOrderNo, select properties, event, double click, code builder.
Paste this in.

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmWorkOrderEntry"
stLinkCriteria = "[WorkOrderNo]=" & Me![WorkOrderNo]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria

This will replace your macro to open the form. What this does is applies a filter when the form is opened. This means that you will have only the one record available through the form until the filter is reset. You can reset the filter through the menu bar. Hope this helps, if you need more code let me know.

 

[MattMeat]

James79,

Thank you so much for this! It worked perfectly. I'm sure you'll be seeing me around this site again. Keep up the great work! I really appreciate it and I'm sure others do too!

MattMeat