 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007cannot edit record in form
Hi! Got following problem: I have a form to insert data. (= creates new records) I have another form to search existing records. When a record is found, I select and open it to edit it. Problem is that I can see everything but cannot edit it. All properties are OK (form properties and field properties) The form is linked to the table (not to query). But I tried linking it to query and got same problem. Any idea what could be happening? PS: sent previous post where I mensioned the "data entry" property, but this property is only for new record creation. Thanks! Nic Nic, If the form is based on a table, and the table is updateable, so should the form. What are your Allow properties set to (AllowEdits, Allow Deletions,...etc) for the Edit form > Problem is that I can see everything... Are you unable to edit an exisiting record, or just a new record.  Signaturehth Al Campagna . Candia Computer Consulting . Candia, NH USA Microsoft Access MVP http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." > Hi! > [quoted text clipped - 16 lines] > Thanks! > Nic Hi, Thx for your reply. AllowEdits, etc are set to yes. Maybe one thing: the tables are in another mdb-file. In the mdb-file with the forms, I inserted the linked tables. Could this be the reason? Thx again! > Nic, > If the form is based on a table, and the table is updateable, so should the form. [quoted text clipped - 22 lines] > > Thanks! > > Nic Nic, >>If the form is based on a table, and the table is updateable, so should >> the form. *Did you try editing the table directly in whatever mdb the failing form is in? Use a query as a RecordSource for the form. Hust include all the fields, and it's the same as using a table. *Now... if you run the query behind the form, is it updateable?? If you can't edit the table directly, or your query behind the form is not updateable, then Your link (or some other complication is amiss) *Also, try moving the failing form to the mdb where the table resides, to see if you have the same problem. Pretty hard to tell what the problem is "remotely", but you first must determine if the table is updateable, and then is the query updateable. Signaturehth Al Campagna . Candia Computer Consulting . Candia, NH USA Microsoft Access MVP http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." > Hi, > [quoted text clipped - 37 lines] >> > Thanks! >> > Nic Hi, Thx for all you help! Table is updatable. Created new form to see and that-one works fine. Also found out something new: normally I use my search-form and then open the final form to edit it. but if I go to "forms" in access and open the form directly: it works: I can edit it. So it's just when I use my search form and open my form that I cannot edit it. Weird...... Anyway, if you got an idea, would be great. Thx!! Nic > Nic, > >>If the form is based on a table, and the table is updateable, so should [quoted text clipped - 54 lines] > >> > Thanks! > >> > Nic Nicholas, You have to read the responses carefully... and answer all questions, whether they appear related or not. >> Use a query as a RecordSource for the form. Just include all the >> fields, and it's the same as using the original table, but... gives you more leeway in >> sorting and filtering. >> *Now... if you run the query behind the form, is it updateable??* You said the "table" was update-able, and the Edit form can be opened manually, and works that way? You'll have to explain where each of these forms (and their associated tables are located). And show your code you use to open the "edit" form from the search form. (Copy & Paste exactly) >> Weird...... Not really... The difference between opening a form manually, and open by code, are the OpenForm method arguments in the code. Review each of the OpenForm arguments in the code that opens the Edit form. Check that your arguments and commas are correct. Particularly the DataMode argument... Signaturehth Al Campagna . Candia Computer Consulting . Candia, NH USA Microsoft Access MVP http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." > Hi, > [quoted text clipped - 86 lines] >> >> > Thanks! >> >> > Nic |
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.