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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/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/
