If [ID#] is Numeric
DoCmd.OpenForm strForm, , , "[ID#] =" & Me.ControlHoldingID
If [ID#] is Text
DoCmd.OpenForm strForm, , , "[ID#] ='" & Me.ControlHoldingID & "'"
You'll need to replace ControlHoldingID with the actual name of the Control, on the first Form, where the ID# is located.
Using this method, you will only be able to work with the targeted Record in the secondary Form.
A different method would be needed if you wanted to be able to work with the targeted Record in the secondary Form and then go to other Records in that Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007