469,602 Members | 1,747 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

If a field is keyed in, then delete other fields

Hi

I have a textbox (Final Flat) that contains a default value of zero. The
other 2 textboxes (Final rate and Final Minimum) always have a numeric value
in them. What i want to do is this......whenever the (Final Flat) is keyed
in, then delete the values in the Final Rate and Final Minimum...........how
would i go about doing this?......thank you!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200509/1
Nov 13 '05 #1
2 1225
James G wrote
I have a textbox (Final Flat) that contains
a default value of zero. The other 2 text-
boxes (Final rate and Final Minimum) always
have a numeric value in them. What i
want to do is this......whenever the (Final
Flat) is keyed in, then delete the values
in the Final Rate and Final Minimum


Assuming the Control is bound to a Field in the RecordSource, in the
AfterUpdate event, put code to test for non-zero and to set the other
Controls to zero. If it is unbound, probably the Lost Focus event would be
best.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
Ok .....this works great.....thank you!....but what if i want to reverse the
process. For instance, what if the person didn't like what they keyed in on
the (Final Flat) and wanted to basically undo what they just did, so the
original values, which were in the (final rate) and (final min) textboxes
before, show up again. How would i go about doin that? thank you!
--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Xah Lee | last post: by
4 posts views Thread by R Bolling | last post: by
1 post views Thread by Don Leverton | last post: by
1 post views Thread by Harry Devine | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.