 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008New 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? >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?  SignatureJohn W. Vinson [MVP] 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 have one form CstIssue, I have an event to open up another form from this > >form. [quoted text clipped - 8 lines] > forms? If they are different tables, are you (improperly) storing the customer > name and phone data redundantly? >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! SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.