You can accomplish this by using a user defined function in the "Row Source Type" of your combo box. The function has to follow certain rules. You can get help how to make such functions in Ms Access help. or MSDN. try searching for "Row Source Type" and you'll get it. Post it again if you still have problems and I'll write that function for you.