(1) Preventing User From Tpying in Cbo
The RowSource of the combox is based on already entered values into a table.
If this is the case then I would go with the code I suggested in post #2. Try it out, see if you like it, or get any errors, then post back with problems or if it isn't quite what you are looking for.
Code:
Private Sub YourCboName_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode <> 9 Then
KeyCode = 0
End If
End Sub
The user can still type in the cbo but when they do Access gives an error telling them what they have typed is essentially 'not valid', and they won't be able to submit that. I don't think you can 100% stop a user form typing onto a combo box (since as I said earlier the combo box is meant to allow that), but I could be wrong!
(2) Auto-Populate the Appropriate Textboxes
User explicitly SELECTS value “GND(2)” from combobox’s columns are populated to relevant fields
For this June7 has provided what you need in post#4.
For each text box you want to be populated type [cboName].[Column](#) as the control source-- where # is the column number from the combo box that has the data for that text box, the first column is Column(0) FYI. So for example from your image above... your 'On Schematic' is Column(0), 'Tested Item' is Column(1), 'Cable Number' is Column(2), and 'Location where cable is connected' is Column(3).
First make sure you have each field you want to populate included in the Table/Query that is the row source for the combo box. Otherwise the fields will not show up in the text boxes you are populating.
(3) Requerying the Textboxes if Not Working
If at first the textboxes do not populate as expected: consider clicking the ellipses (...) next to the After Update event in the event properties tab for the combo box, selecting 'Code Builder' and put in a line of code to requery your textboxes to make sure the data gets pulled correctly. Would be something like
Code:
Private Sub ComboBox_AfterUpdate()
Me.textbox1Name.Requery
Me.textbox2Name.Reqery
'rest of textbox names
End Sub
I know this is a lot to throw at once, and I hope I have all my info correct... but just take it piece by piece, digest it, and report back on any problems!