Go to Specific Record

[mainerain]

I wish to be able to Click on a button that opens another form at a specific Record. Thanks so much.

[CJ_London]

not much to go on to provide a detailed answer.

use the docmd.openform command and complete the criteria parameter which specifies the record you want

[ranman256]

if you mean a record key id
enter the ID# into a box ,
then pressing enter activates the event:

sub txtFind_Afterupdate()
If IsNull(txtFind) Then
   Me.FilterOn = False
Else
   Me.Filter = "[ID#] =" & me.txtFind 
   Me.FilterOn = True
End If
end sub

[mainerain]

Ajax, that was what I was attempting to do but I don't know enough to create proper syntax.

DoCmd.OpenForm FrmFTLoop, acNormal, , ?????

Search for FT-0008A Record in Field FldFTLoopTag on Form FrmFTLoop

[pbaldy]

Ajax, that was what I was attempting to do but I don't know enough to create proper syntax.

This should help:

http://www.baldyweb.com/wherecondition.htm

[mainerain]

pbaldy that helped. Besides entering into a TextBox to specify the desired record and then Click associated Button is it possible to "preset" the desired Record and just Click a button?

[pbaldy]

Sure:

Numeric: "FieldName = 123"
Text: "FieldName = 'abc'"

[mainerain]

Awesome! Thanks so much pbaldy. You made my day.

[pbaldy]

Happy to help!