Posts by ezbie

I am looking for a simple way to get data from an excel sheet and place it into a combobox (the excel data to be the default selection and the remaining options coming from my mdb database) and then update the cell data once it has been changed on my form. I would prefer to have all this happen without opening up the excel document. How would I do this?

My options in my combobox are added from my mdb database... what I need is for each time my form, or program for that matter loads is to have the selected option default to the option that was last selected. So essentially, I need my combo box to "remember" which record was the last one selected by the user. Can this be done, seems like it should be simple but I haven't been able to find the answer.