Lock Subform Query

[wtrimble]

I have a query subform on a form I have, with combo boxes that filter it. I have the query locked so that no changes can be made to query, however, the user is still able to delete records from the query for some odd reason. I have to keep it "enabled" because the user needs to scroll right and left in the query.

Any suggestions on how to disable records from being able to be deleted??

Thanks

 

[pbaldy]

Check out the form's Allow Deletions property.

 

[wtrimble]

Allow Edits was it, Thanks

 

[wtrimble]

Wait nevermind, neither of those works. Disallowing edits disables my combo boxes. Is there any solution?

 

[missinglinq]

In the form your subform is based on use this:

Private Sub Form_Delete(Cancel As Integer)
  Cancel = True
End Sub

 

[wtrimble]

That still doesn't work, seems that the query-subform is it's own identity and doesn't abide by Form properties

 

[pbaldy]

The subform has it's own properties and events. That's where the Allow Deletions should be set to no.

 

[wtrimble]

The query doesn't have those property options. Just locked and enabled.

 

[pbaldy]

Can you post the db?