>Before I transitioned to SQL 7, I would pass a record Id into the
>INIT of a form.
>
>I then did a seek on that record Id, and refreshed the form. If no Id was
>passed in, I called a method to add a new record.
>
>Whats the best way to do this using SQL Server?

What about having a parameterised view based on your record id? you could then just use the view with your variable storing the record id and only get that record for your form.
If no record is found you could then just go about the standard ways of adding a new record.