copy problem

[eran185]

i have a query and i use "count" to get the number of items i have.
then i want to see this number in a form , and i put text box that receive this number.
the problem : i get "#Name?" in my text box
why ?

 

[eran185]

hey

there is a litlle example.

look at the field "test" in the form

 

[stopher]

Don't use an aggregate query to do the count. Instead just put the following in your field:
=Count([קוד זיהוי])

Here I've counted the primary key field to ensure you get a full count of records.

Or you can take a look at the DCount function which allows you to count with a given criterion.

hth
Stopher

 

[eran185]

and if i want to do this field in another form (in that form , i dont have this field) ?

 

[Brianwarnock]

Then you must base that form on the query.

 

[stopher]

What do you want to do exactly?

If the records you want to count aren't in your datasource then use DCOUNT where you can specify the table whose records you want to count.

Chris