If Then - populate a different field based on this result?

  • Thread starter Thread starter SBecker
  • Start date Start date
S

SBecker

I'm relatively new to Access and am trying to build some intelligence into a
database I've got. What I'd like to do is have the users select a loan type
from a drop down box, and if their choice is one of 2 different types (there
are 5 types all together), have it automatically check a checkbox in a
different field. So, can I do an if then on one field and it's results
effect a different field?

I'd love any suggestions!
Thanks in advance...
 
I'm relatively new to Access and am trying to build some intelligence into a
database I've got. What I'd like to do is have the users select a loan type
from a drop down box, and if their choice is one of 2 different types (there
are 5 types all together), have it automatically check a checkbox in a
different field. So, can I do an if then on one field and it's results
effect a different field?

I'd love any suggestions!
Thanks in advance...
Click to expand...

Code the AfterUpdate event of the Combo Box:

If Me.[ComboName] = "xxx" or Me.[ComboBox] = "yyy" Then
Me.[CheckBox] = -1
Else
Me.[CheckBox] = 0
End If
 
Back
Top