Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Carrying over the value of a field to another form?

Status
Not open for further replies.

Tofias1

MIS
Jun 17, 2002
57
US
If anyone could help it would be greatly appreciated. I am creating a mdb and I was wondering how to connect fileds of one form to another form. For an example I would like the primary key of the Parent table to link to a secondary key in another table w / out having to re-enter the P key.

Thanks.
 
Can you give a little more detail about what you are trying to accomplish? e.g., Have you established relationships between the tables? Is your form's primary purpose for data entry, to display existing records, or both?
 
Yes I have set up relationships between the tables. The main table which is named TblClient contains a primary key which would be great if it carried over to TBLComp as the secondary key. Once the primary key is entered in on the form (main tbl) and another one is choosen from that form I would like to see the primary key field that I typed in on the previous one transfer over to the next. I thought this would reduce the amount of typing the same p key everytime for the same client. Thanks for your response I hope this better explains what I would like to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top