In the combo box for the item, put in the Row Source propery a query like this:
Select item, description from items where category = forms![orderentry]![category]
Also, in the Got Focus event of the item, do:
This will cause the combo box to requery if the category has changed
If you move the database to SQL, this should still workout changing anything assuming you link the tables and they have the same names for columns, etc.