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!

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

Populate fields 1

Status
Not open for further replies.
germain2

germain2

IS-IT--Management
Joined
Sep 18, 2007
Messages
30
Location
US
Can someone help me on the issue of populating fields from one field to another.
I have a main table linked to a linking table with other tables attached to the linking table as sub forms. I want the information such as the ID from the Main table to show in the subforms without re-typing. What is the best way to do this?Thanks for your help
 
Sort by date Sort by votes
The usual way is to use the Link Child and Link Master Field properties of the subform control.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kim296
  • Locked
  • Question Question
FILTER SUBFORM USING MAIN FORM FIELDS- VBA
Replies
8
Views
1K
Andrzejek
Andrzejek
priac
  • Locked
  • Question Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
2K
Andrzejek
Andrzejek
StevenFromSouth
  • Locked
  • Question Question
Using .Fields() method in Recordsets for calculations.
Replies
1
Views
349
Andrzejek
Andrzejek
DeRochier
  • Locked
  • Question Question
Conditional formatting on Yes/No fields
Replies
2
Views
609
Axworthy
Axworthy
StanJx
  • Locked
  • Question Question
Filter Or Populate List Box According to Two Date Fields
Replies
1
Views
147
PWise
PWise

Part and Inventory Search

Sponsor

Back
Top