Update unbound box on form...help needed

  • Thread starter Thread starter Fuzzy Logic
  • Start date Start date
F

Fuzzy Logic

I have a form with a calculated unbound box based on a query. If I check a
record on the form for yes to no (or vice versa) this calculated field
should be updated but isn't. What's the proper way to get this to happen?

TIA
 
I have a form with a calculated unbound box based on a query. If I check a
record on the form for yes to no (or vice versa) this calculated field
should be updated but isn't. What's the proper way to get this to happen?

TIA
Click to expand...

Requery the control in the AfterUpdate event of the yes/no field.

John W. Vinson[MVP]
 
Requery the control in the AfterUpdate event of the yes/no field.
Click to expand...

I'm not sure what you mean by 'requery the control'? I know where the
AfterUpdate event is for the field but I'm not sure what's supposed to go
into it?
 
I'm not sure what you mean by 'requery the control'? I know where the
AfterUpdate event is for the field but I'm not sure what's supposed to go
into it?
Click to expand...

Click on the ... icon by the AfterUpdate event and choose "Code
Builder". Access will give you the Sub and End Sub lines below; just
add one more line:

Private Sub controlname_AfterUpdate()
Me!othercontrolname.Requery
End Sub

using your own control names of course.

John W. Vinson[MVP]
 
Back
Top