Solved Being able to disallow data entry (1 Viewer)

[PaquettePaul]

Until the 5th day of the current month when the tax calculations are generated for the prior month, the user is able to change or delete any invoice information for that period. Once the cutoff is reached, I would like to allow the users to view the information but not make any changes whatsoever to records in the prior months. I could go through a process of protecting every field on every subform when those records are selected although I was wondering whether there is a cleaner/easier method. Any suggestions,

 

[KitaYama]

In cases like this, I don't bother with controls or fields. I use form or subform's BeforeUpdate event.
Users are allowed to change everything. But it will never be saved.
If you like you can add a messagebox to warn them the changes were not saved.

Private Sub Form_BeforeUpdate(Cancel As Integer)
 
    If myCondition = True Then
        Me.Undo
        Cancel = True
    End If
  
End Sub

 

[PaquettePaul]

That would work

thanks

 

[The_Doc_Man]

There is also the possibility from your description that in the form's OnCurrent event, you test the day's date against the date on the record and then according to the results, diddle with the form's .Allowxxxx flags. You can start with

Form.AllowAdditions property (Access)

Office VBA reference topic

docs.microsoft.com

And from that page, on the left you can easily get to the .AllowDeletions, .AllowEdits, and any other things you might wish to set or clear. That would be fairly decent as a way to try to block certain actions.

 

[PaquettePaul]

Thank you. Will try both options

 

[Pat Hartman]

I don't like using the Allowxxxx options because it interferes with search boxes if the form has any. I use @KitaYama 's method.