unbound combo box to update list

[Guest]

I have a combo box that is unbound that I'd like to be able to update if
there is new data.

I was looking at Allen Browne's example - http://allenbrowne.com/ser-27.html

however I have a unbound combo box, would anyone know how I could make this
happen?

THANKS!!!

 

[Guest]

Have you tried this code? what happen?

Look at this link, there is another example

http://www.databasedev.co.uk/not_in_list.html

 

[Guest]

Thank you!!! Works like a charm!!!!

Using AB's code gave me a invalid use of ME! error, could be that did not
have the RowSourceType set to the table.

 

[Guest]

In some case the Me!FieldNAme gives an error, next time try Me.FieldName

 

[Guest]

Thank you... I did try that, though after a few attempts I went looking for
an alternate answer which I found. THANKS AGAIN!!!!