Problem... I need the combo boxes to keep the data selected and not clear when the enters a new record. Also, I need the data to stay until user selects something else in the list. It is not necessary for the data to be tied to a field in the table. I can not figure out how to get this result. Can someone help? I havw done the same thing with a date and this works great.
Private Sub date_AfterUpdate()
Me!date.DefaultValue = "#" & Me!date & "#"
End Sub
Private Sub date_AfterUpdate()
Me!date.DefaultValue = "#" & Me!date & "#"
End Sub