Doreen- You must Requery the subform control to get it to not show deleted rows. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/
_____ From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of rokkeee Sent: Friday, June 16, 2006 11:06 PM To: ms_access@yahoogroups.com Subject: [ms_access] #Deleted message shows in form field After entering data on a form with a subform, I click a macro button that runs queries and posts (appends) data to several tables then "cleans" out the original table entries using delete queries. A message box appears to say "This new customer has been saved." After you click the OK button in that message window, #Deleted appears in the fields where the original data was. How can I make the form fields clear out without showing that "error"? I tried using the ECHO feature in my macro, but I'm getting strange results. I want to clear all the form fields before starting to enter new data. Doreen [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
