I have a form using a combobox for letting the user choose a project and to each project a customer is assigned. Now, I'd like to display the customers name after a project is chosen. How do I do this?
Thanks.
I have a form using a combobox for letting the user choose a project and to each project a customer is assigned. Now, I'd like to display the customers name after a project is chosen. How do I do this?
Thanks.
Thanks, Paul!
I've tried that. However, I get a runtime error now saying: "You can't assign a value to this object!".
This problem dissapears, when I remove the Control source of the textbox.
I might mention, that the project is already a cascaded popup box, thus I have
Private Sub cboOEM_AfterUpdate()
Dim strProj As String
cboProject = Null
txtODM = Null
strProj = "SELECT DISTINCT qryProjectOpen.txtProjectName, qryProjectOpen.txtODMName FROM qryProjectOpen "
strProj = strProj & " WHERE qryProjectOpen.lnkOEM = cboOEM.value"
strProj = strProj & " ORDER BY qryProjectOpen.txtProjectName;"
cboProject.RowSource = strProj
End Sub
What am I doing wrong here?
Benjamin
You get an error here?
txtODM = Null
If so, the control source of that textbox would need to be a field name, not:
=ComboName.Column(x)
You want one method or the other, not both.
Thanks again, Paul!
That solved the problem.
No problemo!