Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    forcing a key press

    I have a subb form which has a field that calculates the number of records in a subform =Count(recordfield).. The problem is unless the user doe not hit enter on the last record of the subform, they just use control tab to exit, it does not count the last record entered.. Is there a way to have it force the last record entered to count in this way? Either by a key press or something else? I've tried send keys with not much luck.. Thanks for the help..

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: forcing a key press

    If I understood your post correctly, you can use the Save Record command on the Exit event of the form:

    Private Sub Form_Exit()
    DoCmd.RunCommand acCmdSaveRecord
    End Sub

    HTH[img]/w3timages/icons/thinks.gif[/img]
    -MarkJ-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •