updating a combo box value

#1

I have a combo box that its value is used to calc another value on the
form.

works fine until someone wiped the value from the box and hits tab.
if the drop down showed a value such as 50 and the calculations are
done on that value.
if they wipe it and exit the box the calculations are still done on
the 50 on after update.

any way to get the timing correct with this type of thing so that when
they remove the 50 and exit it is now a null and no calcuations are
done?

#2

sparks wrote:

Quote:

I have a combo box that its value is used to calc another value on the
form.

works fine until someone wiped the value from the box and hits tab.
if the drop down showed a value such as 50 and the calculations are
done on that value.
if they wipe it and exit the box the calculations are still done on
the 50 on after update.

any way to get the timing correct with this type of thing so that when
they remove the 50 and exit it is now a null and no calcuations are
done?

In the AfterUpdate event of the combo something like

Me.CalcField = Me.SomeField * NZ(Me.ComboFld,0)

#3

after update

If (Me!FullVal.Column(1) = 20) Then Me.Final = (.335 X 20)

the problem is you put in debug.print Me!FullVal.Column(1)
pick the 20 and debug.print shows 20 on afterudate

remove the 20 and leave and it will debug.pring 20 again even though
the value was cleared.
I am not sure if the value is actually recorded at a later time or
what.

I need to run and try on exit or lost focus

On Wed, 08 Sep 2010 07:34:52 -0700, Salad <salad (AT) oilandvinegar (DOT) com>
wrote:

Quote:

sparks wrote:

I have a combo box that its value is used to calc another value on the
form.

works fine until someone wiped the value from the box and hits tab.
if the drop down showed a value such as 50 and the calculations are
done on that value.
if they wipe it and exit the box the calculations are still done on
the 50 on after update.

any way to get the timing correct with this type of thing so that when
they remove the 50 and exit it is now a null and no calcuations are
done?

In the AfterUpdate event of the combo something like
Me.CalcField = Me.SomeField * NZ(Me.ComboFld,0)

#4

sparks wrote:

Quote:

after update

If (Me!FullVal.Column(1) = 20) Then Me.Final = (.335 X 20)

the problem is you put in debug.print Me!FullVal.Column(1)
pick the 20 and debug.print shows 20 on afterudate

Why aren't you checking to see if the combo is null is well? Ex:

MsgBox IIf(Not IsNull(Me.Combo1) And Me.Combo1.Column(1) = 1, "OK", "Not
OK")

Quote:

remove the 20 and leave and it will debug.pring 20 again even though
the value was cleared.
I am not sure if the value is actually recorded at a later time or
what.

I need to run and try on exit or lost focus

On Wed, 08 Sep 2010 07:34:52 -0700, Salad <salad (AT) oilandvinegar (DOT) com
wrote:

sparks wrote:

I have a combo box that its value is used to calc another value on the
form.

works fine until someone wiped the value from the box and hits tab.
if the drop down showed a value such as 50 and the calculations are
done on that value.
if they wipe it and exit the box the calculations are still done on
the 50 on after update.

any way to get the timing correct with this type of thing so that when
they remove the 50 and exit it is now a null and no calcuations are
done?

In the AfterUpdate event of the combo something like
Me.CalcField = Me.SomeField * NZ(Me.ComboFld,0)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

updating a combo box value

comp.databases.ms-access comp.databases.ms-access

updating a combo box value - 09-08-2010 , 09:23 AM

Re: updating a combo box value - 09-08-2010 , 09:34 AM

Re: updating a combo box value - 09-08-2010 , 01:44 PM

Re: updating a combo box value - 09-08-2010 , 02:15 PM