RE: [AccessDevelopers] Trying to save a new record in a form

[Robert Peterson]

On a bound form if you put 
me.dirty=false
in the lostfocus event then that will force Access 
to save the record.
Be 
careful however, if there are other required fields in the table that aren't 
entered on the form yet, then there will be an error when you try to 
save.

 
 Bob Peterson


From: AccessDevelopers@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Jose Luis Jr Mora 
JrSent: Friday, December 02, 2005 8:11 PMTo: 
AccessDevelopers@yahoogroups.comSubject: [AccessDevelopers] Trying to 
save a new record in a form

Hi everyone,
 
Is there a way to manually save through a macro and/or VB while a new 
record is being entered in a form?
 
I have a form with the following fields:
 
Date, Time, Initials
 
What I basically want to do is save the new record being entered in the 
form after the focus has been lost on the Date field.  I've tried looking 
at some the books that I have and they all basically say that once the "cursor" 
is moved off the new record, it will be saved.  But what I want to do is 
save it after the first field has been populated.
 
HELP !!!!!!!!!!
 
Thanks,
 
Jose






Please zip all files prior to uploading to Files section.





    


  
  
    SPONSORED LINKS
  
          
                  
            
        Microsoft access developer
      
                      
        Microsoft access help
      
                      
        Microsoft access database
      
              
                        
            
        Microsoft access training
      
                      
        Microsoft access training course
      
                      
        Microsoft access programming
      
              
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.