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
|
|||
|
|||
Form will not allow data entry
Hey everyone. I have researched this topic in some other threads, but
I still cannot figure out how to solve the problem. I have a query that has 5 tables involved (they are linked sequentially using each table's primary key field). I use a combo box to select a specific name for which I want the query to pull data on. The form that opens up displays the data, but I cannot edit any of the fields that I want to edit. None of the fields I want to edit are locked, and all are set to allow data entry. I have seen some posts about the multiple tables possibly being an issue, but I am pretty sure I need all of the tables in order for the query to work properly. I have even used the form wizard function and that did not work. Does anyone have any ideas? Thanks! |
#2
|
|||
|
|||
Form will not allow data entry
mpa.pirate05 wrote:
Hey everyone. I have researched this topic in some other threads, but I still cannot figure out how to solve the problem. I have a query that has 5 tables involved (they are linked sequentially using each table's primary key field). I use a combo box to select a specific name for which I want the query to pull data on. The form that opens up displays the data, but I cannot edit any of the fields that I want to edit. None of the fields I want to edit are locked, and all are set to allow data entry. I have seen some posts about the multiple tables possibly being an issue, but I am pretty sure I need all of the tables in order for the query to work properly. I have even used the form wizard function and that did not work. Does anyone have any ideas? Thanks! A multi-table query is often uneditable. I do not recommend using one as the Recordsource of a form, especially one meant for data entry. If you need to view and edit table from multiple tables, use subforms on your main form. Hope this helps, Scott Microsoft Access MVP 2007 |
#3
|
|||
|
|||
Form will not allow data entry
From Allen Browne, reasons queries are read-only:
http://allenbrowne.com/ser-61.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Form will not allow data entry
On Mar 3, 3:22 pm, "Scottgem (MVP)" wrote:
mpa.pirate05 wrote: Hey everyone. I have researched this topic in some other threads, but I still cannot figure out how to solve the problem. I have a query that has 5 tables involved (they are linked sequentially using each table's primary key field). I use a combo box to select a specific name for which I want the query to pull data on. The form that opens up displays the data, but I cannot edit any of the fields that I want to edit. None of the fields I want to edit are locked, and all are set to allow data entry. I have seen some posts about the multiple tables possibly being an issue, but I am pretty sure I need all of the tables in order for the query to work properly. I have even used the form wizard function and that did not work. Does anyone have any ideas? Thanks! A multi-table query is often uneditable. I do not recommend using one as the Recordsource of a form, especially one meant for data entry. If you need to view and edit table from multiple tables, use subforms on your main form. Hope this helps, Scott Microsoft Access MVP 2007 Thanks Scott! I will try the subforms route. Mike |
Thread Tools | |
Display Modes | |
|
|