Going to a new record. 1

[ncopeland]

Hi

I have a piece of code that opens a form for either adding records or editing records.

I want the code to move to the new record instead of starting at the first record. In other words a new record displayed instead of the records for editing. I hope I have explained this ok.

Any help greatly received.

KR

NC

 

[Remou]

You can use DoCmd.GoToRecord, or you can open the form in add mode:
DoCmd.OpenForm "frmForm", , , , acFormAdd

 

[ncopeland]

Hi Remou

The Add function doesn't allow me to modify any of the other records unfortunately.

The other suggestion I don't think it allows you to say goto new record using that command.

Thanks for the help. Any other suggestions greatly received.

KR

NC

 

[Remou]

DoCmd.GoToRecord , , acNewRec?