Results 1 to 3 of 3
  1. #1
    Mile129 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    11

    adding new blank record help needed

    I have a form and after data entry in the form I have in the last data entry point a Event Procedure to open a new blank form to add another record:



    Private Sub ASRPrepaid_AfterUpdate()
    On Error GoTo Err_btnSave_Click
    DoCmd.GoToRecord , , acNewRec
    Exit_btnSave_Click:
    Exit Sub

    The only problem is when the person entering data hits enter on the last data entry cell it opens a blank form but stays in the same cell (the last data entry cell) I want it to go back to the first data entry cell. Can anyone hep with this command in VB. Thanks

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    please try:
    firstfieldname.setfocus

    after you go to new record.

  3. #3
    Mile129 is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    11
    that works, thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Opening a form at a blank record
    By Remster in forum Forms
    Replies: 2
    Last Post: 09-14-2010, 07:46 AM
  2. Replies: 1
    Last Post: 08-27-2010, 05:16 AM
  3. Adding field to form causes blank view.
    By emccalment in forum Access
    Replies: 1
    Last Post: 04-02-2010, 06:27 PM
  4. blank on entry on add a record form
    By gmee in forum Forms
    Replies: 1
    Last Post: 10-07-2009, 07:31 AM
  5. Add data from previous record if blank
    By mbc321 in forum Queries
    Replies: 1
    Last Post: 08-08-2009, 05:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums