Results 1 to 7 of 7
  1. #1
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50

    when saving a record first one is blank row how to solve

    please find attached table
    when saving a record first one is blank row how to solve. for the firsttime only it happeneds why



    how to solve . Please help me as early as possible
    Attached Thumbnails Attached Thumbnails blank.jpg  

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How are you saving the record?

  3. #3
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50
    Quote Originally Posted by RuralGuy View Post
    How are you saving the record?

    with embedded macro save command button.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is it saving the Form or the record? I'm not very familiar with Macros. I only use VBA.

  5. #5
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50
    Quote Originally Posted by RuralGuy View Post
    Is it saving the Form or the record? I'm not very familiar with Macros. I only use VBA.
    in the subform, i entered fields data when i click on save button. record saved into table. the table looks like above. it happends for the first record only.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You know that Access will automatically save a SubForm record when you move the focus off of the SubForm, right?

  7. #7
    sireesha is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2012
    Posts
    50
    Quote Originally Posted by RuralGuy View Post
    You know that Access will automatically save a SubForm record when you move the focus off of the SubForm, right?
    yes, but clients needed to click on save button only saving. so i am using embedded macro of save command button. it works for all other forms, for this form had this problem. why ? Please help me.

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

Similar Threads

  1. Make form not saving new record right away
    By darekg11 in forum Forms
    Replies: 0
    Last Post: 09-17-2012, 01:22 AM
  2. Replies: 5
    Last Post: 08-21-2012, 12:30 PM
  3. Message Box for Saving Record
    By Mahavir in forum Access
    Replies: 5
    Last Post: 12-29-2011, 12:13 PM
  4. Saving Record
    By mwabbe in forum Programming
    Replies: 12
    Last Post: 09-15-2010, 12:09 PM
  5. record saving twice in table
    By ds_8805 in forum Forms
    Replies: 15
    Last Post: 04-14-2010, 07:16 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