ACESS 2007 forms not populating database column

[jker]

in my table i have two columns
CUST_CONCAT_LONG text
CUST_CONCAT_SHORT text

I created two events as follows:
Private Sub btnSave_Click()


cust_concat_short = CUST_LNAME & ", " & CUST_FNAME & " " & CUST_INITIAL & ",---- " & CUST_PHONE
MsgBox "CUSTOMER: " & cust_concat_short & " *** ADDED/UPDATED ***"


End Sub

Private Sub btnSave_Enter()

CUST_CONCAT_LONG = CUST_LNAME & ", " & CUST_FNAME & " " & CUST_INITIAL & ", " & CUST_PHONE & ", " & CUST_CITY



End Sub



in my click event, CUST_CONCAT_SHORT gets populated because i can see the value in my MSGBOX when it pops up.
CUST_CONCAT_LONG gets populated into my table column,



for some reason, CUST_CONCAT_SHORT does not show up in my table column but it does show as part of my MSGBOX message.


QUESTION: why am i not getting CUST_CONCAT_SHORT populated into my table??

[Welshgasman]

Why have you posted the code twice?

[Micron]

If the forms are bound, you've put the record in edit mode and the result needs to be committed. I can't imagine the purpose of your button "enter" event so you might have to explain why you think it's necessary since it might be playing a part in the problem. You could try adding

If Me.Dirty Then Me.Dirty = False

What seems more of an impending future issue is to save multiple fields in one. You can't do much with it if you intend to query on the field (as an example), it's no good as an index and it constitutes a calculated field, which you should not do in most situations. This has to be one of those situations.

[Micron]

already asked?
https://www.accessforums.net/showthread.php?t=88619