Your DLookup syntax is wrong.

Watch this video: DLookup

Thank You for that.  The expression builder took away all the quotes I had.  I have another question, the next box needs to be populated by a query that has an inner join to a related table.  This query runs fine. what is the syntax to put the query name in the control source?
Also, what is a normal tip for your service?  Is there one?

Make the Record Source of your form whatever your query name is.
Ten you can add any of the fields in your query to the Control Source of your Text Box.

(Make sure the query is updateable otherwise you won't be able to Add or Edit Records)
Not Updateable

If the Recordset is not updateable you can still use DLookup as before using the Query name instead of a Table name.

I am sorry if I am unclear.  When I fixed the syntax, everything worked fine.  Thank You.

My next question is abut filling the value in a second field.  I would rather put the name of the query that works in the control source for that field because that query has an inner join to a second table.  If that is possible, what is the right syntax?  If not can the  Dlookup function handle it?  Thank You

I tired putting the query in the dlookup in place of the table but it gave me errors in syntax

= DLookUp("ContZone", "GetContZone", 'CountryID=" & [Forms]![New Record For Entity]![EntCountryId])

The query GetContZone below, already contains the criteria so including it in the Dlookup is redundant?

SELECT [Continental Zones].ContZones, Countries.CountryID
FROM Countries INNER JOIN [Continental Zones] ON Countries.ContinentalZone = [Continental Zones].ContZoneID
WHERE (((Countries.CountryID)=[Forms]![New Record For Entity]![EntCountryId]));

You have a single quote in front of CountryID instead of a double quote.
If the criteria isn't needed leave it off. It's optional.