Enter value in a form, run query and display result on form

[imellor]

I'm a beginner at Access, but the one thing I have leant is there is often a very simple way of doing a task if you know how.

So before I start looking at VBA and DAO commands.

Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return the value of count function in to anther text box?

Thank you very much for your help.

Regards

Ian

 

[imellor]

You could use the DCount function. In the ControlSource of fieldB -

=DCount("*","tblOrQuery","FieldA = " & FieldA)

Thank you, I knew there would be a simple solution. That saved me some work.

Ian

 

[hhfreddie]

=DCount("*",

Hull Pat, what does the asterist (*) mean in the formula?

Thanks

 

[hhfreddie]

Thanks Pat,

I have grasped that very well.