View Full Version : How do I auto change default values?


mtimko
10-09-2000, 01:02 PM
I have a combo box which I want the default value to be the same value as the last value entered. In essence, I want the default value to remain the same unitl I go to the combo box to change it.. then once changed, use the new value as the default value.

Thanks, I appreciate it!

chrismcbride
10-09-2000, 03:50 PM
If the Combo Box is unbound, then the value in it will not change when you navigate to a new record (ie after saving a record and moving on). You could set up a procedure in the AfterUpdate of the form that would copy the current value of the unbound Combo Box to a field that would save the value in your table. The only problem with this is that, upon opening the form the Combo Box would be empty. Is this a problem?
Good Luck
Chris