A97 bound controls not showing default values in form view on new record?

[MLH]

I have a form used for both editing and the entry of new
records named frmAdminDoListEntryForm. It has 2 fields
on it: ProjName and Rev. The form's record source is qryAdminDoList.

ProjName and Rev textbox controls both have default values.
The first is =GetProjectName() and the second is =GetCurrentRev().

There's a button on the form that runs the following:
DoCmd.GoToRecord , , A_NEWREC

I notice that the ProjName textbox shows the desired string when
I reach the new record and Rev textbox does not. If I run
? GetCurrentRev() in the immediate window, it returns the expected
string. I'm wondering why #Name? shows up in the control? Both
are bound controls. Ideas, hints, suggestions?

[lylefair]

When the developer has demonstrated for several weeks that he/she is
too lazy and/or too stupid to solve even very minor problems, the God
Of Access puts a curse on the application. As a result of the curse
"#Name" is frequently inserted into perfectly wonderful and superbly
crafted controls.
If you don't believe me, search the Help File, and/or
http://office.microsoft.com/en-us/as...e/default.aspx for "#Name"
and see what they say.

[MLH]

Your post is funny, but...
Do you know the answer?

[Trevor Best]

MLH wrote:

I have a form used for both editing and the entry of new
records named frmAdminDoListEntryForm. It has 2 fields
on it: ProjName and Rev. The form's record source is qryAdminDoList.

ProjName and Rev textbox controls both have default values.
The first is =GetProjectName() and the second is =GetCurrentRev().

There's a button on the form that runs the following:
DoCmd.GoToRecord , , A_NEWREC

I notice that the ProjName textbox shows the desired string when
I reach the new record and Rev textbox does not. If I run
? GetCurrentRev() in the immediate window, it returns the expected
string. I'm wondering why #Name? shows up in the control? Both
are bound controls. Ideas, hints, suggestions?

You sure you got the "=" in on the second one?

[lylefair]

Let's all GUESS what MLH's problem is.
Here's my GUESS: The problem has nothing to do with the Default Value
and the GetCurrentRev() function. The problem has to do with the bound
control; there's a syntax error here or the recordsource does not
include the field to which the control is (attempted to be) bound.

[MLH]

Good point. I dbl-checked. Yes, its there. I'm continuing this
in the later thread I retitled, FYI.

You sure you got the "=" in on the second one?