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

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...
 
F

fredg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Populate a table based on check box status 2
Copy previous record into form field 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Auto-populate spreadsheet based on database info? 1
Populate a field based on a different field. 10
Multiple iif challenge 2
Populate a Field 3

Top