Table association Or dependent on field value

[June7]

Select WrenID from combobox and open form with:



DoCmd.OpenForm "NETDataForm", , , "WrenID=" & Me.cbxWren

A bound form with bound controls should automatically show the appropriate record.

The rest of the code makes no sense to me.

[NickWren]

Or is it better if I do it when entering, so when inputting a new sample I want to have the "WrenID", "SampleName", "Facility", and "TestType" not only be put on the bound table, but also written to the correct results table with those 4 fields filled in already. so then all it has to do in the sample status page is look for the samplename and wrenid that associates with it.

[June7]

During data entry is best. But why duplicate the SampleName, Facility, TestType into dependent table?