text box count

[potts]

I've got yet another question.

I have a query that has counted the number of customers related to a session. I want to display this value in a text box on a form for the session as it will form part of a calculation to cost the session for each customer.

I realise I can source the query column in a list or combo box, but I'd rather do this in a text box to aviod errors. does anyone know how this might be done?

 

[adwaitjoshi]

use the on load command

You can calculate the number of entries in the table with the onload event of the form and then pass that number to the text box in which you want to display your total number of participants.