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.
Who is Participating?
Mahdi MansourConnect With a Mentor Design Monitoring & Evaluation ManagerCommented:
just define a new recorde set let say Tmp, and set it to the spicific table and then :


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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.