Input form that does not show exisiting records

[cinders]

Hello,

I need to create a blank form that is soley for input. It will update a table. My issue is that I do not want the form to display any of the existing records in the table. i just want a blank form for capturing data.

Any thoughts on how to do this?

Thanks

Cindy

 

[WayneRyan]

Cindy,

I believe that you can just set the form's data entry
property to yes. Then it can only add records.

Wayne

 

[cinders]

I did that, but I don't want the already entered records to display on the form. I always want it to appear blank after a record is entered or when you open the form. I seem to always see record number 1

 

[ghudson]

Use this command in the forms OnOpen event to force a new record when the form is opened.

DoCmd.RunCommand acCmdRecordsGoToNew

You could also create your own Save Record button and add that command to force a new record after the previous record was saved.

Are you going to allow the users the ability to modify records [just in case they made an error.]?

HTH

 

[cinders]

Thanks that seemed to do the trick!

 

[AccessDeano]

Hi,

I am a complete access newbie.

I need to use the suggestions below with Access 97 but do not understand how I add the code.

I have tried clicking the Expression builder, after right clicking on the form, but everything I enter is invalid.

Would someone please help with this basic task - please

Kind regards

 

[ghudson]

You need to choose "Code Builder", not the expression builder option. Then paste the command above into the controls OnClick event you just created with the code builder.