New to access form question

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

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?
Click to expand...

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?
 
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.
 
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.
Click to expand...

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!
 
Back
Top