Jason,

Again, my apologies for taking so long. I have put together a basic database to show what I was talking about. You can download it from http://echovue.com/costsavings.zip

I put together 3 tables, tblOptions, tblSavings and tblResults, and then put together a a form - frmMain, which is tied to tblResults. I used information from tblOptions and tblSaving to populate the combo box on that table, and if you click the button with the 3 dots next to the Row Source property, it will show you the query I used to populate the combo box. I then created some basic VBA code behind the form to calculate the savings and move the cursor around as the user performs various actions. I also set the start up properties for the mdb, so that frmMain is displayed immediately and the code behind the form, opens up a blank record for the user to input their information. If you want to look at the code behind the form, open it in design view and the goto View - Code or push the View code button on the toolbar.

I did this using office 2003, so it may not open if you are on 2000 or 97, if that is the case, I could probably cobvert it for you.

Let me know if you have any questions, and sorry again for the delay.

Mike

Mike
EchoVue.com