I personally don't know if it is possible to have a field in one table automatically updated when data in a field in another table is changed. What I know is that you can write code in VBA in AfterUpdate event that runs a query that updates a field in the other table. For example you write the following code
Dim stSQL As String, stCriteria as String stSQL = "UPDATE YourTableName SET FieldName = " & Me.TextBoxNameOnForm CurrentDb.Execute stSQL, dbFailOnError where YourTableName is the name of the table, FieldName is the name of the filed in the table and TextBoxNameOnForm is the name of the textbox on the form on which the AfterUpdate event has occurred. If the textbox contains non-numeric data then enclose it in single quotes like stSQL = "UPDATE YourTableName SET FieldName = '" & Me.TextBoxNameOnForm & "'". Please note that there is a single quote soon after the second equals sign and a single quote with double quotes on either side at the end. HTH Liveson ----- Original Message ----- From: Muhamed Faisal To: [email protected] Sent: Tuesday, 04 December, 2007 2:18 PM Subject: [ms_access] table field name dears, There is any way to have a tables field name should automaticaly liknked with another table becuse i want to design a table in there field name should updated utomaticaly from another table any tips pls regrds Faisal Riyadh __________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
