Basic Question

[radicalrik]

When I open a form it goes to the first record of the table. I would like it to go to the last record. How would I do that?

 

[R6Flyer]

DoCmd.GoToRecord , , acLast

 

[Mile-O]

When I open a form it goes to the first record of the table. I would like it to go to the last record.

Do you mean the last in the table or do you actually mean a new record?

 

[radicalrik]

DoCmd.GoToRecord , , acLast

Where would I put the code?

 

[radicalrik]

Do you mean the last in the table or do you actually mean a new record?

A new record

 

[R6Flyer]

on the open event:

Private Sub Form_Open(Cancel As Integer)

Docmd.GoToRecord , , acLast

End Sub

 

[R6Flyer]

In that case change acLast to acNewRec

 

[Mile-O]

Depends how you are opening the form.

• Simply clicking on it
  
  Then, select the Form's properties and find the Form_Load event. Select the button at the right with the three dots and select Code Builder. In this window that opens type: DoCmd.GotoRecord, , acNewRec
  
• By using a macro
  
  With the Data Mode property of the OpenForm method, select Add

 

[radicalrik]

In that case change acLast to acNewRec

Thanks!!!! That worked GREAT!!!!