I cringe at the thought of you using Macros to do this. Sure you don't want to convert them all to VBA code so you can error-trap and debug properly?
Brett DD & RL wrote: > I knew that! Duhhh > > John Viescas <[EMAIL PROTECTED] <mailto:JohnV%40Viescas.com>> wrote: > 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/ <http://www.viescas.com/> > (Paris, France) > For the inside scoop on Access 2007, see: > http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/> > > _____ > > From: [email protected] <mailto:ms_access%40yahoogroups.com> > [mailto:[email protected] > <mailto:ms_access%40yahoogroups.com>] On Behalf > Of rokkeee > Sent: Friday, June 16, 2006 11:06 PM > To: [email protected] <mailto:ms_access%40yahoogroups.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] > > > > > > > --------------------------------- > Do you Yahoo!? > Next-gen email? Have it all with the all-new Yahoo! Mail Beta. > > [Non-text portions of this message have been removed] > > -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/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/
