Form function

[vigvig]

I need to keep a running count on a form of the number of times a L code appears in the 31 fields of the form, the number of times a C code appears in the 31 fields and etc.(There are other codes.) A field can be empty. Only one code will appear in any cell. I have added a calculation box for each code...Now I need "what to put in" that box. Thanks for helping a newbie.

 

[KDg]

Hi,

not exactly sure what you're after. Are the codes already in a table and you're pulling them onto a form ( in which case you could use a query ) or are they now being added? If they're being added you could use an AfterUpdate event to check the value of the box for the relevant codes and either hide boxes on the form to keep track or create some variables .

Can you post more details.