Any on have any ideas about how to do this?

Thanks

Z

I can't think of exactly how to do this, but the code wizard for Combo boxes can build a combo to jump to a particular record. I'd suggest starting with that, and adapting as necessary.

-AJ

Using a combo box for the value, below code will take you t o the desired record.

Private Sub Command14_Click()

DoCmd.GoToControl ("id")
DoCmd.FindRecord Me.cmbGoto, , True, , True, , True

End Sub

-Kerem

Good idea I'll give it a try.

Thanks

Z