cssc1
asked on
How to Update two fields bases on selection in a Combo Box?
PROBLEM
I am trying to automatically update the EmployeeNumber and EmployeeNumber fields in a form based on the selection made in the WorePump combo box?
WHAT I HAVE TRIED
1. Watched how to video on line - still got errors, not work
2. Tried modifying this code I found, still got errors, not work
Private Sub txtStore_AfterUpdate()
combo0.RowSource = "Select IP from Vendors where (Store=" & [Forms]![Project Details]![txtStore] & ")"
combo0.Requery
End Sub
3. I tried putting this code I fould online in the on change event:
me!txtTextBox1 = me!cboComboBox1.column(1)
not work either
HOW TO RECREATE PROBLEM
1. Open application
2. Click the button that says "Sampling Setup"
ANY HELP IS GREATLY APPRECIATED
Silica_App---V5.accdb
Explaination-Image.jpg
I am trying to automatically update the EmployeeNumber and EmployeeNumber fields in a form based on the selection made in the WorePump combo box?
WHAT I HAVE TRIED
1. Watched how to video on line - still got errors, not work
2. Tried modifying this code I found, still got errors, not work
Private Sub txtStore_AfterUpdate()
combo0.RowSource = "Select IP from Vendors where (Store=" & [Forms]![Project Details]![txtStore] & ")"
combo0.Requery
End Sub
3. I tried putting this code I fould online in the on change event:
me!txtTextBox1 = me!cboComboBox1.column(1)
not work either
HOW TO RECREATE PROBLEM
1. Open application
2. Click the button that says "Sampling Setup"
ANY HELP IS GREATLY APPRECIATED
Silica_App---V5.accdb
Explaination-Image.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for helping me
cssc1, You got a little click happy and selected all the answers including your own. That means that no one who reads this question will have any idea what suggestion actually helped. You do us all a disservice by closing questions without either choosing a SINGLE answer or explaining why you selected multiple answers.
ASKER
I am so sorry, I did not mean to do that. Not to make excuses, but I have several handicaps and I am constantly going in and out of hospitals, therapy and many care aids. Yesterday I had a 3 hour surgery to remove my right ear so the doctor could remove the cartlidge from it and use it in another part of my body. The ear was reattached. My fault, I will try harder. I don't mean to cause anyone any problems or stress. Please accept my apology.
Hope you're feeling better.
ASKER
I tried the suggested modification and the WorePump Combobox does not work and the EmployeeNumber and EmployeeTitle do not populate.
Can you please suggest a correction for what I did wrong, thank you
Display-of-what-I-chnaged.jpg
Silica_App---V5.accdb