Immediatly go to desired record?

[Nirious]

I have a form that appends a record to a certain table. When it is done appending the record to the table, it opens a new form (which has that certain table as recordsource) Untill here all goes just fine, but:

Is it possible to when the second form loads or directly after to show the newly added record. Now it always just shows the first record.

ps, I still need to be able to access all the other records on the second form. So I just need to put the cursor on my desired record on the second form, and show the record.

Please help me.

Nirious

 

[maxmangion]

put docmd.openform "formname" , , , "[fieldname]=" & me.fieldname

where fieldname is the name of the primary key of the record you want to go to.