DLookUp help!!

[netguy]

Folks I have read a many different ways to set a default value in a Txt box using DLookUp function. Most of the examples do not show by running against a query . here is my example which does not work.

My saved query (qry_num_prac_no_regions)

SELECT COUNT(tbl_Practices.PRAC_NAME) AS [Practices w/no Region]

FROM tbl_Practices

WHERE (((tbl_Practices.REG_ID) Is Null));

Default value on txt box:

=DLookUp("[Practices w/no Region]","qry_num_prac_no_regions")

I do not have a third parameter set however when I refresh the form I get infamous #Name?

Not sure what I'm doing wrong.

[qa12dx]

=DLookUp("Practices w/no Region","qry_num_prac_no_regions")

[netguy]

The problem I was having is that I was entering this into the default value of the txt field. Instead in needed to go into the Control Source field

Thank you!