Each form I have has a ID number. I have created another form which is used for a different purpose. This form is based on the first form. Each form has similar text fields such as First Name, Last Name, Date, and Phone Number. I wanted to know how to insert the similar data from the first form to the second form so the users do not have to retype the Name, Date, and phone number. In addition, I wanted to make sure the correct forms are retrieved by making sure the ID number of the first form is the same as the second form. I was wondering if someone knew how to do this. Thanks for the help. I really appreciate it.
Question about forms
- Thread starter SD23
- Start date
ansentry
Access amateur
- Local time
- Tomorrow, 06:57
- Joined
- Jun 1, 2003
- Messages
- 995
If I understand your question;
You have a table with customer details and you want a form to use that information to create (say an Invoice Form) data to be held in a second table.
If I am correct in my assumption then to "store" the customer information from table1 in table2 you only have to store the primary key from table1 in table2.
Have a look at my sample here;
>>> Click Here <<<<
If you can't work it out or have any other question, post back.
You have a table with customer details and you want a form to use that information to create (say an Invoice Form) data to be held in a second table.
If I am correct in my assumption then to "store" the customer information from table1 in table2 you only have to store the primary key from table1 in table2.
Have a look at my sample here;
>>> Click Here <<<<
If you can't work it out or have any other question, post back.
