When a Combobox is changesd, it makes a note in a comment field

[DB via AccessMonster.com]

I have a combo box named Location, which has 4 locations in it. I would like
when the field is changed, to make a note on a subform similar to "item
shipped from A to B on date"

Is this possible?

Thanks in advance

DB

 

[tkelley via AccessMonster.com]

It's very possible. Try this ... In the AfterUpdate event of the combo box:

Me!YourSubformName.YourNoteFieldName = "Shipped from A to B on " & Me.
location.value

Let me know ...