Help: Open Form at last Record

[iteach2]

Can someone show me how to open my form so that it opens at record 7 of 7 or even six of seven...Right now when i open the form it only shows record 1 of 1, eventhough there maybe six records in the corresponding table(tblChange). The reason I need this is because I have a search button that searches the (tblChange) table in search of a matching I.D number. Right now this only works when i open the form..I think..in design view. There it shows record 6 of 7. How do I get this to happen when the form opens from the switchboard???

Right now when I try to execute the search button i get
"You can not find or replace row" error message.

(-----I know one of you Guru's can help me with this---)
Signed
(Helplessly new to Access) s-)

 

[braindead2]

to open a from to the last record just do this

DoCmd.OpenForm "formname", , , "Criteria"
DoCmd.GoToRecord , , acLast

to go to a specific record

use this
DoCmd.OpenForm "formname", , , "Criteria"

with criteria being the where part of an SQL statement whith out the where

Good Luck