Not exist in combobox?

[referee]

hi,

on my form (frmtest) i have a combobox(cbolastname) where they select a name from it to store in the record
now when i put a new record and i select a name from the combobox
the names that i see on the form in the other records may not availible in that combobox
have someone have a code to do that?

thanks

 

[WayneRyan]

referee,

Me.YourComboBox.Requery

Wayne

 

[maxmangion]

you can use the onNotInList event to add your selection to the list. There is a good example (code) in the FAQ of this Forum.

 

[referee]

thx for replying

this is the sql for that combobox, but it shows never the availible persons in that combobox
what i'am doing wrong?
thx

SELECT qryReserven.Achternaam, qryReserven.Voornaam, qryReserven.Ploeg
FROM qryReserven
WHERE (((qryReserven.Ploeg)=[forms]![frmtest]![ploeg]) AND ((Exists (SELECT * FROM tblPLANNEN WHERE tblPLANNEN.RESERVE = qryReserven.Achternaam ))=False));