Use A ComboBox to Update A Memo Field

[bestfc01]

Hi All

I am currently using the column history to log the history of inputs into a memo field.

But i now need to swap how my database runs and now require a combo box to have the same history function, as this is for a status updates and i require users to only input certain status's.

I no that I cant use the columnhistory command with a combo box, but could someone help me with the following

When selecting a status from the combo box it automatically update the memo field (which will be hidden on the form) so the columnhistory function works.

Ive tried googling it with no avail and been hitting a brick wall here.

Thanks in advanced

 

[SOS]

If you want to add to the memo field (to the existing contents) you would put this in the After Update event of the combo box:

Me!MemoFieldName = Me!MemoFieldName & vbCrLf & Me.ComboBoxName

Make sure the combo box's bound column is the right one so that the text and not the ID shows up.

If you want a space or separator you could use

Me!MemoFieldName = Me!MemoFieldName & vbCrLf & vbCrLf & Me.ComboBoxName

or

Me!MemoFieldName = Me!MemoFieldName & vbCrLf & "_______" & vbCrLf & Me.ComboBoxName

and so on.