Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

VB and Access

I need to know what code I need to put in that allows the user to enter a new name and phone (the key) on the main form and have the new name and phone number be added to each additional Access table that is used when the user progresses to other forms in the vb program.  I am using ado data controls in the program.

Let me know if I need to go into more detail.
0
jclaire
Asked:
jclaire
1 Solution
 
Richie_SimonettiIT OperationsCommented:
You could save it in global variables and everytime you add, modify a record, add those values in corresponding fields.
Also, avoid usege of data control.
0
 
Mahdi MansourCommented:
just define a new recorde set let say Tmp, and set it to the spicific table and then :

tmp.addnew
tmp("name")=txtname.text
tmp("Phone")=phone.text
tmp.update

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now