Copying unique_ID in subform

  • Thread starter Thread starter John Humble
  • Start date Start date
J

John Humble

The solution to this problem must be very well known, but so far I've not
found it.

My TblBasic in Access 2000 contains Unique_ID as a key. TblDetails (in the
same db) has a Unique_ID field and contains several records per Unique_ID
value. FrmDetails, based on TblBasic, contains an embedded subform based on
TblDetails via a Query. The subform displays all the records in Tbl_Details
corresponding to the value of Unique_ID shown in the main form. Currently
the subform displays the Unique_ID as its first field.

In this scheme I have to manually re-enter the Unique_ID whenever I add a
new record to TblDetails via the subform. This is error-prone. How can I
do this automatically and, if this is possible, can I safely hide the field
from the subform?

TIA

John
 
Open FrmDetails in design view, select the subform control and open the
properties window.

On the Data tab you need to set the Link Child Fields/Link Master Fields.
Put Unique_ID for each.

You should be able to hide the control bound to Unique_ID on the subform
once you're sure it's working. Actually you should be able to delete the
control. As long as Unique_ID remains in the record source for the subform,
you'll be fine.
 
Back
Top