Setting the number of Records on a Datasheet

[henryihunter1954]

I want to set the number of records that can be entered into a datasheet to 3.
How can this be done?

Thanking you in advance.

 

[June7]

You mean a form in Datasheet view?

Set form DataEntry to Yes then something like:

Private Sub Form_Current()
If Me.Recordset.recordCount = 3 Then
    Me.AllowAdditions = False
End If
End Sub

However, if you want to allow viewing existing records and limit data entry to only 3 records, that gets more complicated.

 

[henryihunter1954]

June7, I would like to thank you for the information.

I will give this a try.

Thank all of you for your help with questions regarding MS Access.
I am learning from the advice that I get.

 

[henryihunter1954]

June7, I tried your suggestion.

It worked just perfect.
Thank you so very much.

This is the best group for getting help in regards to MS Access.