refreshing feilds

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

nomad

Thread Starter
Joined
Sep 30, 1999
Messages
407
I am building a database with ms access and I have win 2000. I have built a form and one of the fields is a calculation, but I have to shut down the form and re-open it before it makes the caluculation. Can someone tell me how to update that feild without shutting down the form.

thanx
 

Erm

Joined
Jul 30, 2003
Messages
298
I believe you can either go to the Records menu at the top and click on Refresh...or if you want to keep it form based you could create a button that when you click it, the page will refresh. You can do this using the wizard, create a button with the wizard button depressed on the toolbox, then select form operations under the category's list and Refresh Form Data under the actions list, then follow the instructions. Hope this makes sense, if you need clarification please ask!

Good luck!
 
Joined
Aug 30, 2003
Messages
2,702
>> one of the fields is a calculation

How did you do this? Access Help says the easiest way is -

Plonk a text box (from Control ToolBox) on the form.

Type the expression straight into the box, eg:

=[Sales*.2]

, where Sales is a field name.

HTH,
Andy
 

Erm

Joined
Jul 30, 2003
Messages
298
I've not looked into this, but it should be possible. Make a macro that refreshes/build an event that refreshes and put this in the lost focus property of the calculated field. You may have to put it in a different property, perhaps before update?...You get into the properties of a text box/combo box etc, by right clicking on it in design view of the form and selecting properties.
 
Joined
Oct 13, 2000
Messages
941
First, just to clear up a little terminology: a field is in a table; it is a type of data. A control is what is found on a form, and may or may not be related to a field, or, in your case, a series of fields.

It should be as simple as writing a little macro using the Requery action and the control in question, in the syntax Forms!MyFrmName!MyCalcCtlName , and then setting the AfterUpdate event of the control(s) affecting the calculation to that macro's name. Otherwise, in order to answer your question, please tell us (1) what the control source of the calculated control is, and (2) when you want it updated, i.e. how you're using your form.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top