• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

Save a number in Access Table

Is it possible to enter a numeric value in a form and have access save the value multiplied by 2 on it's table. Not having the actual value that was entered stored on any table... the saved value would be the number on the form times two.

Thanks!

Chris
0
cansevin
Asked:
cansevin
1 Solution
 
Kelvin SparksCommented:
Yes, create a field that is not bound to any field in the table. have a second invisible field that is bound to your actual field that you want value saved in. The on the form fields after update event use something like

If IsNumeric(Me.fieldname) then
    me.actualfield = me.fieldname*2
Else
   MsgBox "The value you entered is not numeric", vbOK, "Invalid Entry"
End IF


Kelvin
0
 
cansevinAuthor Commented:
Thanks Kelvin!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now