Allow Edits problem

G

Guest

I have a form and a subform, I want both of them to [allow edits=no], and
only [allow additions=yes], but when i do this, the sub form doesnt allow me
to enter any new records, if i set again the allow edits = yes it works just
fine, but anyone can edit the records and i dont want that.
I've tried to change this options in the master form and in sub form, but i
just cant make it work.

What am i doing wrong?
 
K

Ken Snell [MVP]

If AllowEdits is set to No, you cannot change or enter any data in any
control, regardless of the setting for AllowAdditions.

Perhaps what you want is to set the DataEntry property to Yes for the main
form and the subform. That setting will allow new records to be added, but
no already entered records are displayed for the user to edit / see.
 
G

Guest

- Thanks for your fast reply
- I've tried this: Form without any sub form, set allow additions = yes and
allow edits = no, and it works, i can add new records but cannot edit the
other records, but if i do this in a form with a sub form it doesnt work

- I done this with the DataEntry = true and it works

Thanks
Pedro Costa


"Ken Snell [MVP]" escreveu:
If AllowEdits is set to No, you cannot change or enter any data in any
control, regardless of the setting for AllowAdditions.

Perhaps what you want is to set the DataEntry property to Yes for the main
form and the subform. That setting will allow new records to be added, but
no already entered records are displayed for the user to edit / see.

--

Ken Snell
<MS ACCESS MVP>

Pedro Costa said:
I have a form and a subform, I want both of them to [allow edits=no], and
only [allow additions=yes], but when i do this, the sub form doesnt allow
me
to enter any new records, if i set again the allow edits = yes it works
just
fine, but anyone can edit the records and i dont want that.
I've tried to change this options in the master form and in sub form, but
i
just cant make it work.

What am i doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top