Simple answer I'm sure

[snicker]

This is an example of a time tracking DB I'm building. This is the problem, after a record gets created it wont display after closing/reopening the form. There is probley a simple explanation. Thx in advance for any help.

Mike

 

[doran_doran]

after update event

use after update event to refresh your form and set focus to form.

 

[snicker]

very nice. Worked like a charm.

 

[dtpetty]

Just curious...

very nice. Worked like a charm.

Do you "refresh / set focus" with a Macro? Can't find those actions. Or is it VBA? If so, what does the code look like please.

 

[snicker]

This is on an [event procedure] of a button so the user can refresh any time they want.

Private Sub btnRefresh_Click()
On Error GoTo Err_btnRefresh_Click


    DoCmd.Requery
Exit_btnRefresh_Click:
    Exit Sub

Err_btnRefresh_Click:
    MsgBox Err.Description
    Resume Exit_btnRefresh_Click
    
End Sub

But really all you need is this

DoCmd.Requery

hope that helps. Let me know if you need more info.

Mike