Originally Posted by
Action82
Is there anyway to have the default value of the cbo set to the highest autonumber? ie. everytime a new choice becomes available, it would be used most of the time so it should be the default, but there are cases where some of the older choices can be selected as well.
Yes, it is very possible and very easy to do this. Here's some VBA code- you'll need to figure out which event you want to trigger it.
Me.combobox.DefaultValue = DMax("FieldName", "TableName")
Replace combobox with the name of your combobox, FieldName with the name of the field that houses the value you're looking for, and TableName with the table's name.
HTH