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] & ")"
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