New Record

[NEEDHELP123]

I have a data entry form. Right now when it opens the first record populate the form. To add a new record the user would have to click "Add". This is confusing. They start modiyiing the data thinking it's a brand new entry.

I would like to modify it so that when the form opens it automatically populate an empty data entry form. Does anyone know how to do this?


Access 2003

 

[MaliciousMike]

I have a data entry form. Right now when it opens the first record populate the form. To add a new record the user would have to click "Add". This is confusing. They start modiyiing the data thinking it's a brand new entry.

I would like to modify it so that when the form opens it automatically populate an empty data entry form. Does anyone know how to do this?


Access 2003

I'm going to assume that the form is set to data entry mode and all additions and deltion setting are "yes"?

 

[Matt Greatorex]

I'm not certain, but maybe something along the lines of adding a DoCmd statement to the 'On Open' event of the form. this could tell it to go to a new record each time (acNewRecord).

i know there are a few posts in the forum on this.

 

[MaliciousMike]

I'm not certain, but maybe something along the lines of adding a DoCmd statement to the 'On Open' event of the form. this could tell it to go to a new record each time (acNewRecord).

i know there are a few posts in the forum on this.

code isn't necessary, but it would work.

On the form properties there is a DataEntry option... put that to yes, and allow edits and additions.

That should work for your needs.

 

[NEEDHELP123]

It worked!

Now my next question is when the user leaves the data entry form and come back all their previous entries are not visible to them (now stored in table). I would like them to modify their previous entries. How do I make it open in "Add" mode but also allow them to see and modify their previous entries?

Any ideas???

 

[Banana]

That is exactly what data entry does. To allow users to go back to old records while starting at new record on opening, you will want Data Entry=No, and Allow Edit=Yes, AllowAdd=Yes. I don't know if you want allow users to delete records. When Data Entry is set to Yes, it will only allow you to add records and view what you've added. Close it, and it is no longer accessible, though the records are saved.

Instead use this in your form's Open Event,

DoCmd.RunCommand acCmdRecordsGoToNew

Matt Greatorex had it right.

 

[NEEDHELP123]

This is exactly what I wanted! Thank you all for helping me.

 

[Matt Greatorex]

Matt Greatorex had it right.

Somebody alert the media, it doesn't happen very often!