Count and Dcount not working

[Lukael]

Hi,

I have these two functions set in Textbox Control source:

=Count([ID_Field])

=DCount("*";"RecordsFromAnotherTable")

Both textboxes are on same form. COUNT function is used to count records on this form, and DCOUNT is used to count records in different table. Both functions work, but when form has 0 records, both function stop working. No errors, but simply not displaying anything. I understand that COUNT should have problems with It, since It's recordsource is 0. But DCOUNT that counts records in another table ? What is wrong ?
I tried with Nz function for count (not working):

=Count(Nz([ID_Field];0))

Anybody have an idea ?

[ranman256]

Check the help for syntax...
dcount("*","table") ' comma delimiter

=count... Works in report/form fields.
NZ.....comma!!

[Lukael]

Hi ranman,

I'm checking all over sites, but haven't found anything to solve this. What I need is only to have textbox that will show number of records of form currently opened, and number of records from table that isn't opened.

[Lukael]

Arghhh,

I figured out what is problem - Allow Additions of form must be set to True, then both of functions work when records are 0. Problem solved.