If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New to access form question
I have one form CstIssue, I have an event to open up another form from this
form. How do I get forexample the Customer name and phone number fields to transfer to the same fields on the follow up form. Is this something done in the Row source? |
#2
|
|||
|
|||
New to access form question
On Wed, 9 Apr 2008 16:22:00 -0700, Rpettis31
wrote: I have one form CstIssue, I have an event to open up another form from this form. How do I get forexample the Customer name and phone number fields to transfer to the same fields on the follow up form. Is this something done in the Row source? It starts with the data. The customer name and phone number should exist only in ONE table; they can be *displayed* on multiple forms if you wish. What is the structure of your tables? What are the Recordsources of these two forms? If they are different tables, are you (improperly) storing the customer name and phone data redundantly? -- John W. Vinson [MVP] |
#3
|
|||
|
|||
New to access form question
My example was not correct. Let me rephrase. I have a form
CustomerServiceIssues that is connected to a table. The quality person reviews this form and if it is required selects the command button to make a new form CarIssue which has its own table called CarIssue. I want the item field and the problem field to self populate in the same named fields in the new form called CarIssue which is from the first form CustomerServiceIssue. "John W. Vinson" wrote: On Wed, 9 Apr 2008 16:22:00 -0700, Rpettis31 wrote: I have one form CstIssue, I have an event to open up another form from this form. How do I get forexample the Customer name and phone number fields to transfer to the same fields on the follow up form. Is this something done in the Row source? It starts with the data. The customer name and phone number should exist only in ONE table; they can be *displayed* on multiple forms if you wish. What is the structure of your tables? What are the Recordsources of these two forms? If they are different tables, are you (improperly) storing the customer name and phone data redundantly? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
New to access form question
On Wed, 9 Apr 2008 17:57:00 -0700, Rpettis31
wrote: My example was not correct. Let me rephrase. I have a form CustomerServiceIssues that is connected to a table. The quality person reviews this form and if it is required selects the command button to make a new form CarIssue which has its own table called CarIssue. I want the item field and the problem field to self populate in the same named fields in the new form called CarIssue which is from the first form CustomerServiceIssue. I'm sorry, but I'll have to reask the question: What is the structure of your tables? What are the Recordsources of these two forms? If they are different tables, are you (improperly) storing the [customer name and phone data] Item field and the Problem field redundantly? I can't imagine that your code is constructing a new Form object or creating a new CarIssue table - if it is, then you're really on the wrong track. Might you not instead just want to have the CarIssue form as a Subform of the CustomerServiceIssue form? Again: what are your tables? What fields do they contain? How are they related? I am really reluctant to try to answer your questions because my answer might be gibberish, since I don't know the context! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|