Default value last value entered?

[J. Keggerlord]

I have a continuous form (frmMain) with a table field value
([tblMain]![volume]) that is selected from a combo box (cboVolume). The form
is used for entering information directly to the table. Is there any way to
code it so the default value for the combo box (cboVolume) is the last value
that was entered into the table? For example, I select the value "Sec 41"
from the combo box and then go to the next record. I would like that to
remain the default value in the combo box for the next five or six records
until I change the value to "Sec 44", after which that becomes the default
value. Is this possible to do? As always, the help is greatly appreciated!

 

[Allen Browne]

See:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

 

[J. Keggerlord]

As always, you're the true Access GOD, AB!

Thank you again!

See:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a continuous form (frmMain) with a table field value
([tblMain]![volume]) that is selected from a combo box (cboVolume). The
form
is used for entering information directly to the table. Is there any way
to
code it so the default value for the combo box (cboVolume) is the last
value
that was entered into the table? For example, I select the value "Sec 41"
from the combo box and then go to the next record. I would like that to
remain the default value in the combo box for the next five or six records
until I change the value to "Sec 44", after which that becomes the default
value. Is this possible to do? As always, the help is greatly
appreciated!

 

[Allen Browne]

As always, you're the true Access GOD, AB!

Thanks, JK, but last time I was talking to Him, I was assured his position
was already taken.