Non-enabled form formatting

[neilmcmor]

I have a form with all fields enabled option set to No. The user must be allowed to click a delete button to delete a record but cannot edit or add records. Is it possible to prevent the fields from greying out in this situation. I have tried by enabling the fields and instead setting the forms 'Allow Edits', 'Allow Additions' options as No whilst leaving the Allow Deletes to yes but this dos not appear to allow deletess!! Any help would be appreciated

 

[missinglinq]

Your strategy with Allow Edits/Allow Additions set to No and Allow Deletions set to Yes should work! My guess is that your form is based on a query, and that your query is Read Only! Take a look at Allen Browne’s white paper at to learn why this could be so!

http://allenbrowne.com/ser-61.html

 

[neilmcmor]

Sorted

The form is based directly on a table Missinglinq. But thanks info from another site it appears to be working now, Solution:-
Enabled = True
Locked = True
for all the fields .

 

[missinglinq]

As I said, your strategy with Allow Edits/Allow Additions set to No and Allow Deletions set to Yes should work unless the underlying RecordSource was Read-Only (which wasn't true in this case). Since this wasn't the case, I did some noodling around and found out that setting AllowDeletions to YES doesn't work if AllowEdits is set to No! My question to the members here is this: Is this a bona fide BUG, or just another QOA (Quirk Of Access) and should it be reported to Micro$oft?