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.
|
|
|
|
|
![]() |
||
Newbie: changing the value of a field on form
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
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 |
|
|
|
|||
|
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. |
![]() |
| Tags |
| newbie, changing, value, field, form |
| Thread Tools | |
|
|
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 |