Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Auto calculate a field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AL Rios - 17 Nov 2007 17:52 GMT
I have a form with the control source
=[txtPr]*[txtImpact]/100

When I tab to another field it calculates correctl. What we need is when a
user enters a value in  the field the value above automatically change
without tabbing to next tab.  

Thank you

AL
fredg - 17 Nov 2007 19:22 GMT
> I have a form with the control source
> =[txtPr]*[txtImpact]/100
[quoted text clipped - 6 lines]
>
> AL

If you enter a value in the control, you must at least exit the
control and go somewhere, otherwise how would access know that, if you
enter a 4 you are not wanting to enter 45 or 456?
If you don't want to go the 'next tab', whatever you mean by that, you
can use the tab order to exit to a different control on the form, or
use the control's AfterUpdate event to set focus to a different
control, or change the Form's cycle property to Current Record.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.