Re: Default value

Tech-Archive recommends: Speed Up your PC by fixing your registry

Tina,

Thanks for your explanation.

The action is taken to select the records based on the default value or
other value entered and get the highest value of other field amongst records
then automatically fill in other field. Is there any other event procedure
to fit for this purpose?

Thanks,

Scott

"tina" <nospam@xxxxxxxxxxx> wrote in message
news:x2v2g.32286$az4.20493@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: add avlue to 2 or more fields ?
    ... Private Sub today_date_AfterUpdate ... To add this event procedure to the AfterUpdate event of the control, ...
    (microsoft.public.access.gettingstarted)
  • Re: Title case using Input masks
    ... you'd have to run the conversion code from the AfterUpdate event of ... AfterUpdate event procedure of each control, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Automatically Fillin Date
    ... You can use the AfterUpdate event of the Date1 control to complete the ... DueDate control. ... procedure) on date 1 it fills it with Date(event procedure). ...
    (microsoft.public.access.forms)
  • 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)