Default value not being displayed

  • Thread starter Thread starter Phyzzz
  • Start date Start date
P

Phyzzz

On a sub-form, I am trying to set a text box default value to that of another
field within the same query by using -

=[DefaultUOM] ("DefaultUOM" being the record source of the other field)

Looking in datasheet or form view nothing is displayed, but if I press CTRL
+ ALT + SPACE it correctly "copies" the information from the other field!!

How do I make it display the correct info without having to press CTRL + ALT
+ SPACE every-time??

Thanking you in advance, please help save my remaining hair!!
 
When is it failing to show up? When you open the form, when it becomes
current, when you change another field?
Try doing a requery on the field on whatever action it isn't working in,
e.g. On Current
 
I have a Combo box to select a record, I currently have a text box showing
the DefaultUOM (which I will delete eventually) and a text box showing the
ActualUOM (this is the one with the default value set as "=[DefaultUOM]"

When a record is selected from the combo box the DefaultUOM is updated, but
the ActualUOM is not.

Confused!!

M Skabialka said:
When is it failing to show up? When you open the form, when it becomes
current, when you change another field?
Try doing a requery on the field on whatever action it isn't working in,
e.g. On Current


Phyzzz said:
On a sub-form, I am trying to set a text box default value to that of
another
field within the same query by using -

=[DefaultUOM] ("DefaultUOM" being the record source of the other field)

Looking in datasheet or form view nothing is displayed, but if I press
CTRL
+ ALT + SPACE it correctly "copies" the information from the other field!!

How do I make it display the correct info without having to press CTRL +
ALT
+ SPACE every-time??

Thanking you in advance, please help save my remaining hair!!
Click to expand...
Click to expand...
 
Instead of using a default value (remove it), in the After Update code in
your combo:
ActualUOM = DefaultUOM
so that every time the combo changes the ActualUOM will requery.

But if you delete DefaultUOM, what will ActualUOM use as the source? If it
is something from the combo, then use that instead in your after update.
ActualUOM = myCombo
or if the value is in the second column of your combo...
ActualUOM = myCombo.Column(1)
Mich

Phyzzz said:
I have a Combo box to select a record, I currently have a text box showing
the DefaultUOM (which I will delete eventually) and a text box showing the
ActualUOM (this is the one with the default value set as "=[DefaultUOM]"

When a record is selected from the combo box the DefaultUOM is updated,
but
the ActualUOM is not.

Confused!!

M Skabialka said:
When is it failing to show up? When you open the form, when it becomes
current, when you change another field?
Try doing a requery on the field on whatever action it isn't working in,
e.g. On Current


Phyzzz said:
On a sub-form, I am trying to set a text box default value to that of
another
field within the same query by using -

=[DefaultUOM] ("DefaultUOM" being the record source of the other
field)

Looking in datasheet or form view nothing is displayed, but if I press
CTRL
+ ALT + SPACE it correctly "copies" the information from the other
field!!

How do I make it display the correct info without having to press CTRL
+
ALT
+ SPACE every-time??

Thanking you in advance, please help save my remaining hair!!
Click to expand...
Click to expand...
Click to expand...
 
Thanks - sorted.

Just to clear up the confussion, I'm not deleting the DefaultUOM from the
query, only the DefaultUOM text box from the form.

Thanks again.

M Skabialka said:
Instead of using a default value (remove it), in the After Update code in
your combo:
ActualUOM = DefaultUOM
so that every time the combo changes the ActualUOM will requery.

But if you delete DefaultUOM, what will ActualUOM use as the source? If it
is something from the combo, then use that instead in your after update.
ActualUOM = myCombo
or if the value is in the second column of your combo...
ActualUOM = myCombo.Column(1)
Mich

Phyzzz said:
I have a Combo box to select a record, I currently have a text box showing
the DefaultUOM (which I will delete eventually) and a text box showing the
ActualUOM (this is the one with the default value set as "=[DefaultUOM]"

When a record is selected from the combo box the DefaultUOM is updated,
but
the ActualUOM is not.

Confused!!

M Skabialka said:
When is it failing to show up? When you open the form, when it becomes
current, when you change another field?
Try doing a requery on the field on whatever action it isn't working in,
e.g. On Current


On a sub-form, I am trying to set a text box default value to that of
another
field within the same query by using -

=[DefaultUOM] ("DefaultUOM" being the record source of the other
field)

Looking in datasheet or form view nothing is displayed, but if I press
CTRL
+ ALT + SPACE it correctly "copies" the information from the other
field!!

How do I make it display the correct info without having to press CTRL
+
ALT
+ SPACE every-time??

Thanking you in advance, please help save my remaining hair!!
Click to expand...
Click to expand...
Click to expand...
 
oui tou

Phyzzz said:
Thanks - sorted.

Just to clear up the confussion, I'm not deleting the DefaultUOM from the
query, only the DefaultUOM text box from the form.

Thanks again.

M Skabialka said:
Instead of using a default value (remove it), in the After Update code in
your combo:
ActualUOM = DefaultUOM
so that every time the combo changes the ActualUOM will requery.

But if you delete DefaultUOM, what will ActualUOM use as the source? If
it
is something from the combo, then use that instead in your after update.
ActualUOM = myCombo
or if the value is in the second column of your combo...
ActualUOM = myCombo.Column(1)
Mich

Phyzzz said:
I have a Combo box to select a record, I currently have a text box
showing
the DefaultUOM (which I will delete eventually) and a text box showing
the
ActualUOM (this is the one with the default value set as
"=[DefaultUOM]"

When a record is selected from the combo box the DefaultUOM is updated,
but
the ActualUOM is not.

Confused!!

:

When is it failing to show up? When you open the form, when it
becomes
current, when you change another field?
Try doing a requery on the field on whatever action it isn't working
in,
e.g. On Current


On a sub-form, I am trying to set a text box default value to that
of
another
field within the same query by using -

=[DefaultUOM] ("DefaultUOM" being the record source of the other
field)

Looking in datasheet or form view nothing is displayed, but if I
press
CTRL
+ ALT + SPACE it correctly "copies" the information from the other
field!!

How do I make it display the correct info without having to press
CTRL
+
ALT
+ SPACE every-time??

Thanking you in advance, please help save my remaining hair!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top