Combo box - Open at last item selected

[mitchy1111]

Hi,

I have a combo box on a continuous form which lists values from a table. When the user selects the first item from the list, how can I get the combo box to re-open at the same point in the list when they move to the next line in the form?

Regards

Mitchy

[RuralGuy]

How about setting the "Default" value: http://access.mvps.org/access/forms/frm0012.htm

[mitchy1111]

Thanks RuralGuy, think I am almost there with your solution. I can get it to assign the default value of a text field, but I need it to assign the default value to a combo box with a numeric datatype. I get the error 'object doesn't support this property or method'.

I have the following code which you suggested:

Const cQuote = """"
Me!ID.DefaultValue = cQuote & Me!ID.Value & cQuote

As the field is a number I tried removing the quotes, but got the same error.

Thanks