I wrote in my previous posting that the code needs to be in the *form's* Load
event. You have posted code for the combo box OnLoad event. Maybe there is
such a thing in Access 2007 (there is not in Access 2003), but in any case
the code needs to be in the form's Load event. You have not mentioned
whether you moved the code there, but the most recent posting of the code
indicates it is still in the combo box OnLoad event, whatever that is.

Does the code compile?

Scott_Brasted wrote:
Hi, setupID IS the primary key.

That combo searches using SetupID.
From reading through all your previous posts, I assume that the primary key
[quoted text clipped - 19 lines]
Thanks,
Scott

--
Message posted via http://www.accessmonster.com