PC Review


Reply
Thread Tools Rate Thread

After update event

 
 
=?Utf-8?B?Q2Fyb2wgU2h1?=
Guest
Posts: n/a
 
      8th Dec 2006
When I enter sale price for a car in my form, I then go to the next field to
"check" warranty or as is. I like it to automatically do it when sale price
is less than $2000. That way If user enter sale price like $1980, it would be
AS IS, no warranty. Thanks so much for any and all help!!!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?RXJpYyBCbGl0emVy?=
Guest
Posts: n/a
 
      8th Dec 2006
In the after update event for the sale price put
if me.saleprice < 2000 then
me.checkbox = -1
else
me.checkbox = 0
end if

"Carol Shu" wrote:

> When I enter sale price for a car in my form, I then go to the next field to
> "check" warranty or as is. I like it to automatically do it when sale price
> is less than $2000. That way If user enter sale price like $1980, it would be
> AS IS, no warranty. Thanks so much for any and all help!!!

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Before update, after update or change event? or does it matter? Chris K Microsoft Access Form Coding 0 3rd Oct 2010 10:02 AM
Run a Event Procedure and Macro in the Before Update Event Frank Microsoft Access Form Coding 5 12th Jan 2008 12:50 AM
Update combo box in subform (After Update event) =?Utf-8?B?S2FybA==?= Microsoft Access Forms 10 4th Apr 2006 07:45 PM
Is it possible to stop the Update in a Before Update event? Randi W Microsoft Access Forms 2 28th Oct 2004 01:55 PM
change event/after update event?? scrabtree23 Microsoft Excel Programming 1 20th Oct 2003 07:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:28 AM.