Loading cob.Rowsource on click

[ChristinaFC]

I have a cbo which is (and should be) mostly empty. However, when I click on it (but before typing anyting) I would like it to be populated with a rowsource. Once I start typing, it will wait until three letters are typed in before populating it with a new row source. The latter part I have figured out, but the former does not work.
Currently the code is:

Private Sub cboOrgnrID_Click()
Me.cboOrgnrID.RowSource = "SELECT ListaFtg, OrgnrPID FROM qryFtgsLista WHERE ""OrgnrPID = ""&Me.OrgnrID"
End Sub

However, when I click on the cbo, nothing happens.
I would greatly appreciate helt.

 

[PHV]

I'd try to use the Change event procedure and the Text property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

When you say a 'new' row source, do you mean an entirely new range or the existing range extended by one row?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}