I use a SQL DELETE statement to delete a record in a form. The statement 
is attached to a command button.

When the record is deleted the textboxes  have  #DELETE in them.
I try to Requery, and Refresh but it does not work.

How can I remove these without closing and reopenint the form.

thanks

Are you using a bound text box? then just move to the next record after the
delete SQL
if not reset the value of the text box after performing the delete SQL
issue the refresh command




                                                                                                                                    
                      ququmber@h...                                                                                             
                      com                      To:       access@p...                                                        
                                               cc:                                                                                  
                      07/26/2002 02:03         Subject:  [access] sql delete statement                                              
                      PM                                                                                                            
                      Please respond to                                                                                             
                      access                                                                                                        
                                                                                                                                    
                                                                                                                                    




I use a SQL DELETE statement to delete a record in a form. The statement
is attached to a command button.

When the record is deleted the textboxes  have  #DELETE in them.
I try to Requery, and Refresh but it does not work.

How can I remove these without closing and reopenint the form.

thanks