If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New record on form not inserting?
Hello,
I just noticed this behaviour on a couple of my forms, I think specifically where there is data linked from another table, so maybe that could be the source of the problem? Anyways, here is what is happening: I click on the new record button in the navigation toolbar. I enter the required information, and then try to click on next record, or any record navigation button for that matter, and it does not change records. The button depresses, but nothing happens. It also won't let me change to design mode when I enter this new record information. When I close the form with the 'x' at the top right of the form, then open the form back up, I confirm that the new record was NOT inserted. Has anybody had this situation happen to them, and can you tell me some signs to look for to fix this? Thanks in advance, Dana S. |
#2
|
|||
|
|||
Hmm... Ok, I think I located the source of the problem. I hadn't inputted a
required value which did infact link it to another table. I am assuming that is the problem with my other form. Trial and error trial and error and success! "Dana809904" wrote: Hello, I just noticed this behaviour on a couple of my forms, I think specifically where there is data linked from another table, so maybe that could be the source of the problem? Anyways, here is what is happening: I click on the new record button in the navigation toolbar. I enter the required information, and then try to click on next record, or any record navigation button for that matter, and it does not change records. The button depresses, but nothing happens. It also won't let me change to design mode when I enter this new record information. When I close the form with the 'x' at the top right of the form, then open the form back up, I confirm that the new record was NOT inserted. Has anybody had this situation happen to them, and can you tell me some signs to look for to fix this? Thanks in advance, Dana S. |
#3
|
|||
|
|||
Dana,
I think your suspicion is right. Open the underlying query. You may see a phrase like "not an updateable query". It's usually because you are missing primary keys from the other linked tables in your query. Good luck. Geof. -----Original Message----- Hello, I just noticed this behaviour on a couple of my forms, I think specifically where there is data linked from another table, so maybe that could be the source of the problem? Anyways, here is what is happening: I click on the new record button in the navigation toolbar. I enter the required information, and then try to click on next record, or any record navigation button for that matter, and it does not change records. The button depresses, but nothing happens. It also won't let me change to design mode when I enter this new record information. When I close the form with the 'x' at the top right of the form, then open the form back up, I confirm that the new record was NOT inserted. Has anybody had this situation happen to them, and can you tell me some signs to look for to fix this? Thanks in advance, Dana S. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form in Edit Mode | JN | Using Forms | 0 | July 12th, 2004 05:47 PM |
Pop up form doesn't link correctly, PLEASE HELP!!! | Sandra | Using Forms | 4 | June 19th, 2004 01:55 AM |
From a report record to the specific record in a form | Sierras | Using Forms | 1 | June 18th, 2004 02:54 PM |
Populate two+ fields on a Form, based on a pop up form's record | Michael Miller | Using Forms | 0 | June 9th, 2004 02:56 PM |
Form Does Not Go To New Record | Steve | New Users | 1 | May 12th, 2004 03:15 AM |