one record at a time

[ake]

hi!can somebody help me to set my form to allow additions only once?Meaning
every time the form is opened it would allow additions but not more than once.

Thanks!

 

[John W. Vinson]

hi!can somebody help me to set my form to allow additions only once?Meaning
every time the form is opened it would allow additions but not more than once.

Thanks!

You could close the form in the form's AfterUpdate event, but I cannot imagine
any reason why you would want to annoy your users in this way!

What's the logic here? Why do you feel the need to do this?

 

[Mr. B]

ake,

With your form in design view and the Properties dialog box open, modify the
following properties of your form:
On the Format Tab:
Record Selectors = No
Navigation buttons = No

On the Data tab:
Data Entry = Yes
This change will cause the form to only allow new records to be added.
If you want to use this form to edit the same data, then you would not want
to keep this setting.

On the Other tab:
Cycle = Current Record

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm