I have a form based on a number of tables, in one of these I have a combo box based upon the table "priorities" this consists of two fields, "priority" and "description", Description being "Now" and Priority being "1". For ease of data entry I want to show the Description on the form but put the corresponding Priority number in the resulting table.
Is there an easy way to do this, Pleeaase?

Yes, there is a way of doing this.

You need to create a new combo box, using the wizard. Enter the field you want to see listed, if the number is set to the primary key, in the table, this should be automatcailly added as well. It should say, hide key coloumn. Go though all steps, and this should work for u

Oh yes, it can be done!!
Put a combobox control on your form to invoke the combobox wizard. Select the "Lookup values based on a table or query"(you could also choose the lookup record to display specific information-either one)Once you have chosen the table that this information is coming from(Lookup table??) then select both the priority and description for the combobox. When you get to the next screen it will ask you to hide the key, unhide it--Although it is recommended to hide it, unhide it anyway. You can physically hide it by clicking and dragging the column until you can't see that field anymore in this page(but it is still there-per se). Then next screen should ask you what field you would like to store in the database--You wanted priorities, right??? Choose it and you are on your way--Oh it will also ask if you want to use this data for something else or store in a field-That is up to you! Hope that helps! This works for me, you might have an additional field called ID or something that might change this a little bit.

Thanks Ann that did the trick