|
 |
access thread: updating 2tables by one form
Message #1 by "Ahmed Khamis" <Ahmed.Khamis@v...> on Sun, 21 Jul 2002 13:59:05 +0200
|
|
I have a data base with 2 linked tables
How can I update the fields of the 2 tables by using one form
Best regards,
Ahmed Khamis
Vodafone Egypt
Customer operation
Mob: xxx-xxx-xxxx
Ext:56-1107
Ahmed.khamis@v...
Message #2 by "Leo Scott" <leoscott@c...> on Sun, 21 Jul 2002 21:35:45 -0700
|
|
Use a recordset in VBA code and on the form's AfterUpdate event use code to
update the other table. If you don't know how to do this with VBA I don't
know of another way to do it.
|-----Original Message-----
|From: Ahmed Khamis [mailto:Ahmed.Khamis@v...]
|Sent: Sunday, July 21, 2002 4:59 AM
|To: Access
|Subject: [access] updating 2tables by one form
|
|
|I have a data base with 2 linked tables
|
|How can I update the fields of the 2 tables by using one form
|
|
|Best regards,
|
|Ahmed Khamis
|Vodafone Egypt
|Customer operation
|Mob: xxx-xxx-xxxx
|Ext:56-1107
|Ahmed.khamis@v...
|
|
|
Message #3 by "Gregory Serrano" <SerranoG@m...> on Tue, 23 Jul 2002 19:11:09
|
|
Ahmed,
<< I have a data base with 2 linked tables
How can I update the fields of the 2 tables by using one form >>
If the two tables are related via a key field, e.g. Employee ID, create a
query with both tables in it with a relationship between the two tables'
key fields. Include in the output to your query all fields from both
tables. Then base the form on that query.
Greg
|
|
|
View Cart
