🚀 go-pugleaf

On Sun, 3 May 1998 21:26:49 +0100 in comp.databases.ms-access, Scott
Mordecai <Scott@musicman.demon.co.uk> wrote:
>Hi, I hope I can make some sense here...
>
>I have a form which has basic record details (person's name, telephone
>number, etc.). On this form is a datasheet sub-form where I can list a
>number of items. I would like to limit the number of entries on this
>datasheet.
>
>e.g. the datasheet has two fields, "Name" (linked to the main record
>table) and "Item". I would like each "Name" to be allowed only a maximum
>number of items.
>
>Any help, if the above makes any sense, is appreciated!

Assuming the foreign key in the subforms recordset is called "FK" then:

Sub Form_BeforeInsert(Cancel As Integer)
  If DCount("*","ThisTable","FK = " & Me!FK)>=3 Then
    Cancel = True
    Msgbox "Rassssssssssssp!"
  End If
End Sub

You can replace DCount() with tCount() from the downloads section of my
FAQ, it's usually faster than DCount, especially over networks.

                    \|||/
                    /   \
                   C o o D
-----------------ooO--u--Ooo-------------------------------
To reply by mail, replace the "nospam" in my address with "trevor",
then replace the "o" in easynot with an "e".
But please DONT cc me in on posts, I read this group as well.
MS Access FAQ now available on my site below.
http://www.trevor.easynet.co.uk/

Roget's Thesaurus rules - ok, all right, very well, you bet, certainly