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
|
|||
|
|||
Select vs update Query
I'm trying to create a form that I can use to update
individual records. I created a select querty to identify the record, but I can't seem to update the record information. the properties of my form are set correctly so I'm not sure why this is happening. Do I need to do a command when the form is opened to empty the field of the existing informaoitn to allow it to be editted? thanks |
#2
|
|||
|
|||
Select vs update Query
1. (More common) Have you checked whether the Select Query / SQL String is
updateable? Queries that combine 2 or Tables may not be updateable (depending on the joins used). Open the Query by itself, i.e. not through the Form, and see if you can update the data in the DatasheetView of the Query. Also, if you don't see the "New Record" row, your Query is not updateable. If this is the case, check Access Help on "Updatable Queries" which shows a few techniques of converting a non-updateable Queries to updateable. 2. Have you checked the AllowEdits Property of the Form? If the AllowEdits is set to False, you won't be able to edit any Record. Also, check the Locked Property of the Controls. -- HTH Van T. Dinh MVP (Access) "Joyce" wrote in message ... I'm trying to create a form that I can use to update individual records. I created a select querty to identify the record, but I can't seem to update the record information. the properties of my form are set correctly so I'm not sure why this is happening. Do I need to do a command when the form is opened to empty the field of the existing informaoitn to allow it to be editted? thanks |
Thread Tools | |
Display Modes | |
|
|