Populate TextBox based on ComboBox Selection

[dharanez2036]

Hello,



I made this OT Calculator in Excel using VBA and trying to do the same thing on MS Access. Need help on how I can get the value on TextBox when I make the selection on ComboBox.

I have 3 ComboBox. ComboBox1 for Position, ComboBox2 for Step and ComboBox3 for Status. Once I select all 3 values and Click the Calculate Button I want it to give me the value on TextBox (TextBox1 for Base Pay and TextBox2 for OT Rate). This was the code used in excel.

If ComboBox1.Value = "Accountant" And ComboBox2.Value = "1" And ComboBox3.Value = "Employee" Then
TextBox1.Text = "$2000.00"
End If

If ComboBox1.Value = "Accountant" And ComboBox2.Value = "1" And ComboBox3.Value = "Employee" Then
TextBox1.Text = "$25"
End If


This is not working for MS Access. I have also attached the Form Design. Thank you for help in advance.

[Micron]

"Not working" is of no help. You posted the same code 2x except one is supposed to result in $25 and the other (same code) is supposed to result in $2000.
Aside from that, there are so many possible reasons for why it "doesn't work" that there's no way for us to know where to begin.

[dharanez2036]

"Not working" is of no help. You posted the same code 2x except one is supposed to result in $25 and the other (same code) is supposed to result in $2000.
Aside from that, there are so many possible reasons for why it "doesn't work" that there's no way for us to know where to begin.

On second code it's supposed to be TextBox2.Text = "$25" not TextBox1

[dharanez2036]

Basically what I am trying to do is when I select the values for 3 ComboBoxes and Click Calculate Hours Button it will populate the Base Pay and OT Rate and do the Calculation. I have attached the Zip Access file. Thank you.

[Bob Fitz]

Basically what I am trying to do is when I select the values for 3 ComboBoxes and Click Calculate Hours Button it will populate the Base Pay and OT Rate and do the Calculation. I have attached the Zip Access file. Thank you.

I notice that your form module does NOT have the following two lines at the very top:

Option Compare Database
Option Explicit

They should be the first two lines of every code module.
Also, Your code makes reference to Textbox4 but you don't have a "Textbox4" on your form.

[dharanez2036]

That might be a typo but basically I have 3 TextBoxes... Based on ComboBox values first TextBox is supposed to return Base Pay, second TextBox is supposed to return OT Rate and third TextBox is supposed to do the calculation. My issue is after selecting the values from 3 ComboBox and clicking the Calculate Hours Command Button the values are not populating on two TextBoxes (Base Pay and OT Rate).