Newbie: changing the value of a field on form

This is a discussion on "Newbie: changing the value of a field on form" within the Databases section. This forum, and the thread "Newbie: changing the value of a field on form are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Dec 11th, 2005, 22:54
New Member
Join Date: Dec 2005
Age: 57
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Newbie: changing the value of a field on form

Hello...

I am a newbie to Access or any database for that matter. So please be gentle.
I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game.
On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database.
In Amt1 I would like to typein an amount and have it multiplied by 15% (.015).
I fiddled with the "On Enter" in the Amt1 property box but got nowhere.
Can someone help???

Thanks for your time
d9085@hotmail.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Dec 12th, 2005, 18:08
New Member
Join Date: Dec 2005
Age: 57
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Newbie: changing the value of a field on form

For those of you that read this and are confused as to solving this problem I was fortunate enough to get some help.
Here is how it was solved:
Using the Code Builder on the After Update line in the properties box for Amt1 I type:
Amt1=Amt1+(Amt1*.15)

Hope this helps someone else

Last edited by d9085; Dec 12th, 2005 at 18:13.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
newbie, changing, value, field, form

Thread Tools

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 On

Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple form field calculation thenamenoonehastaken JavaScript Forum 2 Feb 21st, 2008 22:32
Form with confirm password field dhossai JavaScript Forum 28 Dec 16th, 2007 05:12
[SOLVED] Field validation and changing display properties... c_martini JavaScript Forum 12 Sep 25th, 2007 11:27
Number validation in form field Matc JavaScript Forum 2 May 26th, 2006 15:05
Add a form field csa Web Page Design 8 Nov 23rd, 2005 20:33


All times are GMT. The time now is 00:56.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved