🚀 go-pugleaf

On Mon, 4 May 1998 17:48:05 +0100 in comp.databases.ms-access, Scott
Mordecai <Scott@musicman.demon.co.uk> wrote:
>>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
>
>Thanks for that, but I'm afraid I have no idea where I should enter it.
>One of the before/after update field options perhaps?
>
>Cheers,
>-- 
> \|||/  Scott Mordecai
>< o,o > mailto:scott@musicman.demon.co.uk
>  \_/

Sub Form_BeforeInsert
    ^^^^
    Clue #1
            
Sub Form_BeforeInsert
         ^^^^^^^^^^^^
         Clue #2

In the form properties (event properties), select "BeforeInsert", select
"[Event Procedure]" from the drop down list. Now hit the builder button
next to it (the one marked "...").

                    \|||/
                    /   \
                   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