Form doesn't repaint data of changed field

[twgonder]

I've got a form, on it is a field that I calculate a value for.


If the field is null, this code runs onenter:

Private Sub tbxm_EntityCd_Enter()
  If IsNull(Me!EntityCd) Then
    Me!EntityCd = fGetSeqId("tbl_39_Entity", "EntityCd", "sTestTwg", True, True)
    Me.Repaint
  End If
End Sub

After it runs, the form textbox doesn't show the value.
If I press tab, then it shows correctly as it moves to the next textbox.

Why isn't repaint repainting the form for this procedure?
(I don't want to refresh or requery as the record isn't ready to save yet.)
Is there a better event to load a value into for a field on a form?

Thanks

[June7]

Is EntityCd a field in table you want to populate? Why save calculated value? Why not put function call in textbox ControlSource?

Probably doesn't show because data is not committed to field until leaving textbox. If textbox has same name as field, try Me. instead of Me!. I always name control different from field, like tbxEntity.

Repaint should not be needed.

[twgonder]

Is EntityCd a field in table you want to populate? Why save calculated value? Why not put function call in textbox ControlSource?

Let's call it more of a calculated default value. The user can stay with it or change it, as suits their needs.

Probably doesn't show because data is not committed to field until leaving textbox. If textbox has same name as field, try Me. instead of Me!.

I would like to show the default value when entering and before leaving the textbox, thus giving the user a chance to see what it is.
I often have a problem with Me! working (compiling), and then, with some other change, not working, and then Me. will compile. I've yet to figure out that little stumper.

I always name control different from field, like tbxEntity.

Like this? (This is what I already had)

Repaint should not be needed.

Under what condition in this case?
Form.Repaint method (Access) | Microsoft Learn

[CJ_London]

I often have a problem with Me! working (compiling), and then, with some other change, not working, and then Me. will compile. I've yet to figure out that little stumper

The '!' is late binding, it is used when the value is not known at compile time. The '.' is early bound and means the object is known at compile time. If not found the compile fails. So if you use '!' the compiler won't fail, but it will fail at runtime if the object is not found.

Always better to use '.' as a) this will pick up on missing objects and b) enables the use of intellisense because the objects are known and listed.

[Gicu]

And try to use Me.Recalc instead of Me.Repaint and see what you get.

Cheers,

[twgonder]

I figured it out. I'm still getting up to speed on the black box which is Access.
I changed Me!EntityCd to Me!tbxm_EntityCd and it works, even without the repaint. (See posts 1 & 3)

[Welshgasman]

Hardly a black box issue.?
With any programming language, you have to get the names correct.

[moke123]

I changed Me!EntityCd to Me!tbxm_EntityCd

And if you typed Me.tb intellisense would have filled it in for you. no spelling or reference mistakes.

[CJ_London]

I'm still getting up to speed on the black box which is Access.

since you want to avoid most of what access offers, I guess it will remain a black box