subform design help

[Guest]

I have created a form with a subform containing 16 different columns (I want
it to appear in datasheet view for the user to manipulate). What I need is
for each form record to be able to contain 11 or less subform entries, but
then have the subform blank for the next entry. I have tried to set it up,
but currently it retains the subform entries when I go on to the next main
form entry which I do not want it to do.

I have tried looking at the Northwinds database because although this is not
order entry, the order entry form/subforms ultimately do the kind of
manipulation that I need to do. The purpose of my form is to detail the
various failures that have a occurred on a part and the actions taken in
response to it (each failure has 16 columns worth of information). Each form
entry needs to contain the information specific to that part in the main form
and all the failure/repair information for that one part in the subform
section.

 

[Allen Browne]

Open the main form in design view.

Right-click the edge of the subform control, and choose Properties.

On the Data tab of the Properties box, set the Link Master Fields and Link
Child Fields properties.

 

[Guest]

Jman,

You need to set the LinkMasterFields and LinkChildFields properties of the
subform to the name of the corresponding field, presumably something like
PartID. Then each main form record (a single part) will OWN the detail
records.

As far as I know, there's no simple way to limit the number of detail
records to 11 without managing it with code.

Sprinks