automatic update after amendment

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,

I posted the below yesterday and used the response which
works fine, but was wondering if its possible to take it
a bit futher and actually get it to update the
field 'Order Date' automatically to todays date after the
field 'State Type' is ammended to D*, P* or C*. Hope
that makes sense!

Cheers

I have a field where the user selects letter D P OR C
which denotes the priority of the order. If at a later
date the priority is upgraded then D*, P* or C* are input
to show that it has changed. Is there any way I can
display a msg box to tell the user to change the order
date when D*, P* or C* are selected
Click to expand...
..

place the following in its
AfterUpdate event...

If Right(Me![TextBox], 1 ) = "*" Then
MsgBox"Don't forget to change whatever!"
End If
 
Hi,
Make these changes:

If Right(Me![TextBox], 1 ) = "*" Then
Me.OrderDate = Date()
End If

--
HTH
Dan Artuso, Access MVP


Steve said:
Hi,

I posted the below yesterday and used the response which
works fine, but was wondering if its possible to take it
a bit futher and actually get it to update the
field 'Order Date' automatically to todays date after the
field 'State Type' is ammended to D*, P* or C*. Hope
that makes sense!

Cheers

I have a field where the user selects letter D P OR C
which denotes the priority of the order. If at a later
date the priority is upgraded then D*, P* or C* are input
to show that it has changed. Is there any way I can
display a msg box to tell the user to change the order
date when D*, P* or C* are selected
Click to expand...
.

place the following in its
AfterUpdate event...

If Right(Me![TextBox], 1 ) = "*" Then
MsgBox"Don't forget to change whatever!"
End If
Click to expand...
 
Back
Top