If you only want a specific Record in the Form's RecordSource, check the
WhereCondition argument of the OpenForm Method.

If you want the Form's RecordSource to have all rows unfiltered, then use
the OpenArgs argument of the OpenForm Method to pass the value that
identifies the Record you want and use this in the Form_Load (or Form_Open)
Event to navigate to the required Record.

Check Access VB Help on the WhereCondition argument and the OpenArgs
argument odf the OpenForm Method.

--
HTH
Van T. Dinh
MVP (Access)




wrote in message
...
Hi

When I have opened up my form I want to jump to a specific
record. Is this possible, and how?

Do I have to use some magic RunCommand constants ??