combobox value dependant on value in control

[JeroenMioch]

I have a control called Pnummer (its personell number).
After a user enters this number i want my combobox called Kenteken (Licenseplate number) to fill with only the licence plate numbers of the employee from the table Parkeerbeheer (Parking management)

Should be simple enough, its like cascading comboboxes but then with only one combobox.

So i put this code in the afterupdate event of the Pnummer control :

On Error Resume Next
   kzlKenteken.RowSource = "Select parkeerbeheer.kenteken " & _
            "FROM parkeerbeheer " & _
            "WHERE parkeerbeheer.pnummer = '" & fldPnummer.Value & "' " & _
            "ORDER BY parkeerbeheer.kenteken;"

I have left the rowsource blanc as above code handles that.

The only thing that comes to mind why it doesn't work is that the table bound to this form is NOT the source where i pull the licenceplate numbers from.


Any idea's or help is greatly appreciated, after trying for two days now im pulling my hair out !

[June7]

pnummer is a text field type, not number?

Have to requery the combobox.

You say the control is pnummer but you have it as the field in the sql and you have fldPnummer as the control name. Which way is correct?

Why not set the sql directly in the RowSource property?

SELECT kenteken FROM parkeerbeheer WHERE pnummer = [fldPnummer] ORDER BY kenteken;

Then the event code is just:

Me.Kenteken.Requery

[JeroenMioch]

Sorry June the control is indeed fldPnummer. The field in the table is Pnummer.

In the afterupdate event of fldPnummer i put

me.kzlKenteken.requery

But still the combobox remains empty
Im pondering what im doing wrong..

Oh and btw, the field is text indeed.

[June7]

The list is still not showing items?

Want to provide db for analysis? Follow instructions at bottom of my post.

[JeroenMioch]

That isnt possible, db is far too large :P
Im gonna try something else, ill let you know how it works ou

Thanks for the time mate !

[ItsMe]

Have you tried removing "On Error Resume Next" from your code in post #1 and then running your app?