Copying unique_ID in subform

[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

 

[Joan Wild]

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.