default value taken from last record

[bopkid]

I have a combo box on a form which looks up its options from a table. Usually the option chosen is the same as the last record, so I want to make the option chosen in the last record the default value in the present form to save time. I know I should probably use the 'default value' box in the property sheet but I don't know how to point to the last record - any ideas?

 

[DES]

On the after update event of the combo box have it set the default option to the current selection.

 

[bopkid]

absolute genious - except it doesn't work for some reason.
I can see in the property sheet that the default value IS changing to the current value but for some reason when I go onto the record it says '#Name?'. I don't know if this is maybe because the 'value' is actually text or maybe the fact that it is looking up values from a table is messing it up. Also, the combo box before it requeries it on its afterupdate event.

 

[DES]

If you would like to send me a copy to play with you can.

technoweenie@sympatico.ca

 

[The_Doc_Man]

I believe you can use CTRL+' (control/apostrophe) for the purpose you have named. Help topic is "Shortcut Keys"