Having trouble with Default Values in forms when value is a constant or another form control

  • Thread starter Thread starter Herb Martin
  • Start date Start date
H

Herb Martin

Access 2003 if it matters.

What is the secret here? Sometimes the form seems to reflect what I have
typed for this property and sometimes it doesn't.

Other times what are clearly correct references work, then don't, then work
again when using values from other controls (text controls.)

I know this may sound vague but the behavior here just seems
unpredictable and erratic.
 
I know this may sound vague

Yep - sure does.
What is the secret here? Sometimes the form seems to reflect what I have
typed for this property and sometimes it doesn't.
Click to expand...

Are you saying that when you type something into a control that fails to
appear in the control - or it is after some event (close, requery, move to
other record, etc) that the input data is missing/wrong
Other times what are clearly correct references work, then don't, then work
again when using values from other controls (text controls.)
Click to expand...
Which references. primary field/controls, goto's, etc

Can you give more details or the problems - are they access or other (ie.
keyboard, windows, etc). On a form, in a table, in a query, etc etc
 
Wayne-I-M said:
Yep - sure does.


Are you saying that when you type something into a control that fails to
appear in the control - or it is after some event (close, requery, move to
other record, etc) that the input data is missing/wrong
Click to expand...

Both, but it isn't related to queries as these are unbound control-fields
being
give defaults or having defaults calculated from other controls-fields on
the
form.

FYI: It's an Email (sub)form based on a client/customer record so that
email can be sent to the client. Putting in defaults for "From:", "To:"
(based
on customers email address) etc.
Which references. primary field/controls, goto's, etc

Can you give more details or the problems - are they access or other (ie.
keyboard, windows, etc). On a form, in a table, in a query, etc etc
Click to expand...

On a form, text boxes.
 
Wayne-I-M said:
Yep - sure does.


Are you saying that when you type something into a control that fails to
appear in the control - or it is after some event (close, requery, move to
other record, etc) that the input data is missing/wrong

Which references. primary field/controls, goto's, etc

Can you give more details or the problems - are they access or other (ie.
keyboard, windows, etc). On a form, in a table, in a query, etc etc
Click to expand...


Apparently it is also some bug/feature of Access since after closing the
database-app/Access and re-opening it my fields not look like I worked
(so long) to make them look.

Changes were not reliably propagating from the Control Properties to
the actual form control properties.

Access 2003 SP2
 
Am a little lost with this. Are the text boxes illed with data stored in a
table - as you say they are unbound - is there a reason for this. Are you
setting the default with vba (have a you a sample if so).

If your boxes hold the "From:", "To:" data where are you getting this from
in the unbound boxes.

Sorry to sound dim but I can't see your app and don't really understand what
you are doing

Can you bind the boxes to table fields ??
would this not sovle the problem
 
Don't assume that access will propogate any changes in the table field. I
know you're supposed to but I find it's simpler not to. If you make any
changes to table fields that alter the properties it better to assume it
won't work and delete the original bound control and re-insert from the field
list. At least this way you'll know the changes are there where you want
them
 
Wayne-I-M said:
Am a little lost with this. Are the text boxes illed with data stored in a
table - as you say they are unbound - is there a reason for this.
Click to expand...

Yes, there is no reason to save this data -- it is for a generated email
that the user can edit. The "customer's" email address is the Default
but the user can change this if he/she wishes.
Are you
setting the default with vba (have a you a sample if so).
Click to expand...

No, just in the control properties.
If your boxes hold the "From:", "To:" data where are you getting this
from
in the unbound boxes.
Click to expand...

From the (hardcoded) Control Properties -- later I MIGHT change some
of this to come from User or System defaults (for From: address, or CC:
and BCC:) but the To: will probably always default to the customer
email address elsewhere on the same form.

Sorry to sound dim but I can't see your app and don't really understand
what
you are doing
Click to expand...

Not at all -- having someone else explain their own stuff is the
responsibility
of the person who needs help (i.e., *ME*)
Can you bind the boxes to table fields ??
would this not sovle the problem
Click to expand...

Sure, but that isn't really appropriate here and all I wish to do is use the
Control "Default" property to put some SUGGESTION into those fields.
 
Wayne-I-M said:
Don't assume that access will propogate any changes in the table field. I
know you're supposed to but I find it's simpler not to. If you make any
changes to table fields that alter the properties it better to assume it
won't work and delete the original bound control and re-insert from the
field
list. At least this way you'll know the changes are there where you want
them
Click to expand...

So are you saying this stuff is intermittently buggy?
 
Back
Top