Retain previous entry in combo box

[rick roberts]

I have a simple combo box in a form which lists corses stored in a table
Since new records tend to be inserted en bloc for a particular course id llike the combo box to retain the last course name and insert it in the default value of the combo
This would automatically populate the combo with the same course til changed - and then carry on with the new course in the same way - -does that make sense?
Ive tried the DMax route but it doesnt seem to work
Any suggestions gratefully appreciated
thanks

forgot to mention - i could get round this by not making the table alphabetical - that way the last course would literally be that - the last in the table but i wanted to keep it alphabetical

 

[pbaldy]

See if this works for you:

http://access.mvps.org/access/forms/frm0012.htm

I'd put it in the after update event of the combo.

 

[rick roberts]

thanks very much - it seems to have done the trick right away - il ltake a proper look tomorrow and see what it does and how it works
thanks again

 

[pbaldy]

Happy to help.

 

[rick roberts]

ive had a look at this but cant figure out what it does - so many quotes within quotes - could you explain how it works please?
"""""" & Me!comboCourse.Value & """"""