 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Form will not open to 'new record'.
I have one form in a database that is giving me fits. It will not open to a 'new' record for entry of new data. I set the data dentry property to 'yes' and it doesn't work. I created a macro to go to a new record and placed it in the 'on click' event on the form and that does not work. The form always opens to the first record in the underlying table. The form is not directly tied to the table but gets its data from a query based on the table. Any suggestions?  SignatureDMainland My guess is that your query is not updateable. You can't add new records to it, nor can you edit or delete existing records. Chris Microsoft MVP >I have one form in a database that is giving me fits. It will not open to a >'new' record for entry of new data. I set the data dentry property to 'yes' [quoted text clipped - 3 lines] >tied to the table but gets its data from a query based on the table. Any >suggestions? I have a similar problem, and I suspected something like that might be the issue, but how do you make the query updateable? I have a query that simply combines two tables into one, and I have a form based on that query, which I want to use to add records to both tables simultaneously. For me, though, it does add records, but the problem is, if I close the form and reopen it, despite the fact that the query shows records, the form shows only a single, new (blank) record. Any suggestions? Thanks, Ray > My guess is that your query is not updateable. You can't add new records to > it, nor can you edit or delete existing records. [quoted text clipped - 9 lines] > >tied to the table but gets its data from a query based on the table. Any > >suggestions? Change the form's data entry property to No to see all the query's records. Chris Microsoft MVP >it does add records, but the problem is, if I >close the form and reopen it, despite the fact that the query shows records, >the form shows only a single, new (blank) record. Any suggestions? |
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
|
©2008 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.