Updating field on Form

  • Thread starter Thread starter Berny
  • Start date Start date
B

Berny

Can anyone help or point me in the right direction on this one?



I have a Form which includes two fields the [rate] that I want to update
based on another field [skill] that is changed by the user.



The [rate] field is used in calculations; however, I can't get the [rate]
field to update after the [skill] field is changed.



The form is bound to a query. I tried a Lookup query that performs the
updates fine, however because of the size of the table the query takes 2
minutes to run. Without the additionally joined table (table2 which has the
rate information) it runs in seconds.



Is there a way to have the field updated using some kind of function?



Or how do I have the record update itself after I change the [skill]?



VBA?



After updating will it stay on the same record?



Any help will be greatly appreciated!!!!
 
thanks for the tip

matt weyland said:
On the afterupdate event for the field that drives the
other field:

me.refresh
-----Original Message-----
Can anyone help or point me in the right direction on this one?



I have a Form which includes two fields the [rate] that I want to update
based on another field [skill] that is changed by the user.



The [rate] field is used in calculations; however, I can't get the [rate]
field to update after the [skill] field is changed.



The form is bound to a query. I tried a Lookup query that performs the
updates fine, however because of the size of the table the query takes 2
minutes to run. Without the additionally joined table (table2 which has the
rate information) it runs in seconds.



Is there a way to have the field updated using some kind of function?



Or how do I have the record update itself after I change the [skill]?



VBA?



After updating will it stay on the same record?



Any help will be greatly appreciated!!!!


.
Click to expand...
Click to expand...
 
Back
Top