Limiting dates entered in a subform

[jsbarroso]

I have a subform which users log their daily working hours (Mon - Fri) for 2 weeks. The subform is limiting the number of records to 10 or less. I would like to begin including the weekend in the form but don't want to include them as part of the 10. Any ideas? :banghead:

Here is my code which works fine if I am only looking at the recordcount values.

The date field is [Reporting Date]

Private Sub Form_Current()
If RecordsetClone.RecordCount >= 10 Then
Me.AllowAdditions = False
Else
If RecordsetClone.RecordCount <= 10 Then
Me.AllowAdditions = True
End If
End If
End Sub

 

[Old Man Devin]

Do you only want weekend to appear in a special case, so normally users can't put in anything more than the 10 week days? i.e. you can't just allow 14 entries and include the weekends normally as they won't always need to use them.

Perhaps have an 'Overtime' box the user can tick which causes the form to swap from allowing 10 records to allowing 14 so they can include weekend entries, or something like that?

 

[jsbarroso]

I believe separating the entire overtime reporting process is the best way to go. Thank you again!