Re: Default value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

when you set the DefaultValue property of a field in a table, or bound
control in a form, the value is assigned programmatically - therefore the
control's AfterUpdate event does not run.

what action are you taking on the AfterUpdate event of the control? can you
run it at some other point in the form?

hth


"Scott" <NoSpam-ScottXe@xxxxxxxxx> wrote in message
news:eIm60sjZGHA.5000@xxxxxxxxxxxxxxxxxxxxxxx
I use after update event procedure in a field of form and it works fine.
However, once I put a default value, i.e., Date(), the after update event
procedure does not work at all. Can someone advise what are the
differences
between no default value and default value and how to resolve it if
default
value is needed.

Thanks,

Scott




.

Relevant Pages

  • Re: GoToControl with selection in a Combo Box
    ... Private Sub Stage_AfterUpdate ... "Jeff Boyce" wrote: ... (like the AfterUpdate event of your combobox) ... go to the Primary Loss Reason Control. ...
    (microsoft.public.access.formscoding)
  • Re: GoToControl with selection in a Combo Box
    ... Private Sub Stage_AfterUpdate ... "Jeff Boyce" wrote: ... (like the AfterUpdate event of your combobox) ... go to the Primary Loss Reason Control. ...
    (microsoft.public.access.formscoding)
  • Re: GoToControl with selection in a Combo Box
    ... "Jeff Boyce" wrote: ... (like the AfterUpdate event of your combobox) ... go to the Primary Loss Reason Control. ... because I never get an error message on it. ...
    (microsoft.public.access.formscoding)
  • Re: Showing/Hiding Subform
    ... All are linked by control "TransactionID". ... sbfrmOrderDetails has a control called "cboProductDescription". ... I want to keep the sbfrmProdSerialNum hidden, ... Code will go on it's AfterUpdate event I know. ...
    (microsoft.public.access.forms)
  • Re: Cancel a change in the before update event of a txtbox
    ... Allen Browne - Microsoft MVP. ... The undo works in the before update event of an option ... >>Bill, if you do go with the AfterUpdate event, you can get away with ... >>warn that you cannot undo a control in its AfterUpate event. ...
    (microsoft.public.access.formscoding)