Show last value in combo box (1 Viewer)

[boycie]

Hi,

By default, when a form opens, for a combo box, I want to show the last value in the list ie. the max of id field. How can I do this?

The reason: There are values being entered in a form but then someone else uses that data and it would be good to load the last value rather than searching for it. Hope Ive made sense

thanks

 

[vbaInet]

You can do something like this:

with me.combobox
    .Value = .itemdata(.listcount - 1)
end with

where combobox is the name of your combo box.

 

[John Big Booty]

You could also put the following in the Default Value Property of your Combo Box;

=[URL="http://www.techonthenet.com/access/functions/domain/dmax.php"]DMax[/URL]("YourFieldName","YourTableName")

 

[boycie]

They both work. Thanks very much to you both