 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Delete Record #Name?
Hi, I've got a Main form with two subforms, 1 & 2. 1 is based on a query that is joined to the underlying table that 2 is used to enter data for. I added a button to Form 2 which deletes the current record from this table. Form 1 requeries On Current and after I've deleted a record and the Requery fires On Current, all of the records are replaced with #Name?. I've tried using Me.Refresh and Me.Requery to alleviate the problem, but the only way to solve it is the close the form and then reopen it.... It seems there must be a way to code the requerying of the underlying data but I'm not sure how to do it...any thoughts? Thanks in advance. Have you tried to run the requery in the function for the delete button. You can try using something along the lines of Forms!mainform.requery > Hi, > [quoted text clipped - 11 lines] > > Thanks in advance. I tried to have that after the delete record commands but I was requerying the subform (1). Maybe I should try on the Main form though...I'll let you know how it goes. Thx. >Have you tried to run the requery in the function for the delete button. You >can try using something along the lines of Forms!mainform.requery [quoted text clipped - 4 lines] >> >> Thanks in advance. hmm, same thing happens when I tried to requery the Main form... >I tried to have that after the delete record commands but I was requerying >the subform (1). Maybe I should try on the Main form though...I'll let you [quoted text clipped - 5 lines] >>> >>> Thanks in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.