Use the AfterUpdate event procedure of the combo to set its DefaultValue
Private Sub cboAmPm_AfterUpdate()
With Me.cboAmPm
If Not IsNul(.Value) Then
.DefaultValue = """" & .Value & """"
End If
End With
End Sub
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John Burns" <Jo*********@BAESYSTEM.con> wrote in message
news:40********@baen1673807.greenlnk.net...
This should be a nice easy one for you lot.
I have got a Combo box, with its source as a value list - there are only
two options, AM and PM.
I want to set a default value in the box, depending on what the value for
the field was in the last record.
In other words I want to fill out a form, and select either AM or PM in
the list, then in the next record I want the AM/PM box to automatically take
the value that was last used.
Thanks
JB