Requery

  • Thread starter Thread starter Reggie Laffond
  • Start date Start date
R

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.
 
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.
Click to expand...

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]
 
Back
Top