Dynamically criteria

[Mikki]

I have two fields on the main form and I need a total count of records between the value of the two and then enter the total in a bound field on the main form

 

[bob fitz]

You could use an expression in the Control Source property of a textbox to do the calculation, but the result would not usually be saved to a table. Better to use the expression and do the calculation when and wherever it is needed.