Counting the results from a listbox

[shaz123]

Is it possible to count the amount of records in a listbox on a form.?

 

[Remou]

The ListCount property returns the total number of data rows, or the total number + 1, if Column Headers is set to Yes.

 

[shaz123]

Hi thanxs fot that, i have set the column header to yes. The listbox is based on the number selected within a combobox, once this is selected there can be a number of orders within the Listbox, I wanted to show the number of orders in the listbox within a txt box on the form

 

[Remou]

You can set the textbox to reference the property:

No header row:
=[List0].ListCount

Header row:
=[List0].ListCount-1

 

[shaz123]

Were would i put that coding, within the properties of the textbox

 

[shaz123]

Its ok sorted it thanku so much