Generating a count of select records 1

[MisterrMac]

I have a simple one table DB where I am tracking incidents. On the incident input form I want to have a total count of an entered incident number from the table.

In other words, when I select or enter a number in one form field (IncidenID), I want another form field (Count) to output the number of times this incident number appears in the IncidentID field of the database.

*Incidents Table*

RecordID -- Date/Time
IncidentID -- Number
UserName -- Text
Details -- Memo

Thanks in advance!

 

[PWise]

in the IncidentID field after update event put this code
me!count = dcount("IncidentID","Incidents Table","IncidentID=" & me!IncidentID)

 

[MisterrMac]

THANKS! That was it!