Tetbox text depending on a combobox.

[schwabe]

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.

[pbaldy]

Does this fit the situation?

BaldyWeb - Autofill

[schwabe]

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

[pbaldy]

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.

[schwabe]

Thanks again, Paul!

That solved the problem.

[pbaldy]

No problemo!