By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
MLH
Your post is funny, but...
Do you know the answer?
Nov 13 '05 #3

P: n/a
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?
Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

P: n/a
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?


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.