I knew that! Duhhh
John Viescas <[EMAIL PROTECTED]> 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/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of rokkeee
Sent: Friday, June 16, 2006 11:06 PM
To: [email protected]
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]
------------------------ 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/
