When VBProper works or NotWorks?

[Rich_Lovina]

I am using this in an After_Update in a form for data-entry, but just added it to a calculated (concatenated) fld.

Why doesn’t it work under this situation?
Nor also when I add a new record, it does not update the concatenated fld until next record. Any short-term solutions?

Tks in advance, anyone.

 

[Travis]

In Access the After_Update Event does not fire if code changes the value of the Field. You will need to Call the After_Update Event when actions occur that effect the field.

 

[Rich_Lovina]

Tks, but I'm not understanding yr 2nd sentence; or are you saying:

A/Update is sitting in the wrong place viz. If fldA + fldB 'create' fldC the A/Update must be in properties fldB, and NOT fldC?

 

[Fornatian]

What you need to do is under the code that 'creates' fieldC call fieldC's afterupdate event.

Me.FieldC = Me.FieldA & " " & Me.FieldB
FieldName_AfterUpdate

Ian

 

[Rich_Lovina]

Tks, found my problem. I created the concateFldC with a QryMakeTable, so of course nothing happens when I enter a new record.
What simple code shld I put to create C, assuming it goes in After_Update of FldB.
Sorry still bit dumb with vb but gettin there.

 

[Fornatian]

Either move the concantanated value out of the query and onto an unbound control, or requery the record source.