🚀 go-pugleaf

On Wed, 6 May 1998 22:12:36 +0100 in comp.databases.ms-access, Scott
Mordecai <Scott@musicman.demon.co.uk> wrote:

>Clue #3 - if I'd had more than five seconds to learn Access and produce
>an application I wouldn't have had to ask! (The last time I wrote an
>application dBase III was *the* database to use!)

I hope you realise that I wasn't having a pop at you, merely giving
pointers as to you to understand where code goes so when others give you
form_afterupdate or fieldname_dblClick then you'll know.

>By the way, one of the suggestions here works a treat, the other gives
>an error (the "Dcount" version), probably me just not understanding the
>command and therefore not typing it in properly.

If the foriegn key field in question was text then that would have been:

DCount("*","ThisTable","FK = '" & Me!FK & "'")

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