Form record entry question

[mergle]

I have searched the threads but can't find what I'm looking for...

I have a form to enter records...I would like the form to open in Add mode, but also allow record editing capability at the same time...Is this possible?

Thanks

 

[llkhoutx]

Set the following form properties to Yes

Allow Form View
Allow Datasheet View
Allow Pivot Tbale View
Allow Pivot chart View
Allow Edits
Allow Additions
Allow Deletions

Set the following to No
Data Entry

With the form's properties as above you'll be able to do just about anything.

 

[mergle]

My form properties are currently at these default settings...What I need the form to do is open in Add Mode, but also allow edits to existing records concurrently.

Thanks.

 

[llkhoutx]

Use the navigation buttons at the bottom of the form; click a "new record" (the asterick) and add you data.

 

[neileg]

Mergle, your question is contradictory.

The Add mode only allows users to add records, not edit them, that's the point.

If you want to edit records too, you need edit mode.

Perhaps what you want is to open the form in Edit mode, but use the on open event to move to a new record. This will make the form look like it's in Add mode, but all the records will be availble for editing.

 

[mergle]

Yes Neileg...your suggestion is exactly what I would like to accomplish!...Could you help me with the code to insert in the OnOpen event?

Thank you for your help.

 

[Rich]

DoCmd.GoToRecord , "", acNewRec

 

[mergle]

Rich,

Thank you.