Improve company productivity with a Business Account.Sign Up

x
?
Solved

Acess, Field in Form View not calculating on key enter

Posted on 2011-03-09
6
Medium Priority
?
303 Views
Last Modified: 2012-05-11
I have a field named [Cost 1] with the following property  =[JCOST1]/(1-[MUP1]) where I enter a value into [JCOST1] which is then divided by the value I enter into [MUPI1].  In my earlier version of Access when I entered a value in [JICOST1] the value in [MUP1] would instantly appear when I clicked "Enter".  In Access 2010 it doesn't; I have to page up two or three records and then back to the new record for the calculation to take effect.

Any suggestions?

oneputt
0
Comment
Question by:2putt
  • 2
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 750 total points
ID: 35097715
Although you should not have to ... you may need to use Me.ReCalc in the Afterupdate Event of those two text boxes where you are entering values ... eg:

Private Sub JCOST1_AfterUpdate()
   Me.ReCalc
End Sub

mx
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35097737
Kindly check your statement for you might want to appear the value automatically to [Cost 1] not [MUP1]?

If you are really referring to MUP1, then there might be a code or macro in the enter event of [JICOST1]  that trigger to display the value at [MUP1] which might not be supported by 2010.

You may check this out.

Sincerely,
Ed
0
 

Author Closing Comment

by:2putt
ID: 35099894
Being that I don't know anything about code, at first I copied the entire code into the space and kept getting an error.  Finally I just copied the middle line of the code and it worked perfectly.  Thank you very much for your assistance.
0
 
LVL 75
ID: 35099939
You are welcome.

Sorry ... I should have noted ".. which will look like this ..." ... ie, just enter the one line of code.

mx
0
 

Author Comment

by:2putt
ID: 35100251
Thanks.  Your clarification confirmed that my guess was correct.  All is working fine now.  Thanks you again.

oneputt
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question