[MS_AccessPros] Add/Delete record on the same form

 

I have a form with data source from a query. I would like to allow the user to create new record(s) (base on a button on the form header) and to delete selected records (base on a button next to the record display).

However, if I enable the "Allow additions" attribute on the form, there is always a 'new record' appears at the end of the form which I don't want it to appear until the 'Add/Create' button is clicked. If I set the "Allow additions" to NO, the create new button will not work.

The code for the create new record is
DoCmd.GoToRecord , , acNewRec

and the code for the delete is

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

How do you circumvent this problem? Thanks.

Thomas

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___