Requery

[Reggie Laffond]

I have a continuous form with a unique customer key as one of the fields on
each line. Is there a way in code to determine the value of the key field
that is in the first row? If I use Forms!frmMain.KeyField I get the row that
has focus but I want row 1 no matter what row has focus.

I want to reposition the form exactly as it was after I issue a
"Forms!frmCustometList.Requery" in code.

Thanks for the help.

 

[John Vinson]

I have a continuous form with a unique customer key as one of the fields on
each line. Is there a way in code to determine the value of the key field
that is in the first row? If I use Forms!frmMain.KeyField I get the row that
has focus but I want row 1 no matter what row has focus.

I want to reposition the form exactly as it was after I issue a
"Forms!frmCustometList.Requery" in code.

Thanks for the help.

Put a line

DoCmd.GoToRecord acForm, Me.Name, acFirstRecord

at the point that you want to reset to the first record.

John W. Vinson[MVP]