whitelockben
Registered User.
- Local time
- Today, 17:20
- Joined
- Jun 29, 2011
- Messages
- 25
Code:
Private Sub cboC_AfterUpdate()
On Error Resume Next
txtW.RowSource = "Select tblCables.W " & _
"FROM tblCables " & _
"WHERE tblCables.T = '" & cboT.Value & "' And tblCables.C = '" & cboC.Value & "' And tblCables.N = '" & cboNCA.Value & "' " & _
End Sub
I have used RowSource, but I am not sure if this is correct. All I want is to have three comboboxes and when each has been selected a spefic piece of info getting from tbl.Cables based upon those selections.
It doesnt have to be distinct because each value will be unie and there will never be more than one record which matches any combination of the three comboboxes.
Thanks in advance!
Ben