Only allow 1 record on a subform

[cmmd2003]

Is there a way that allows one subform record per parent record.

See attatchment

 

[MajP]

If you can only have one record then get rid of the subform. Bind the tables in a query by order ID. Now just add the fields to your main form in tabular fashion. The subform is not doing anything for you if you can not have more than 1 record.

If you can have more than 1 record, but this is a data entry form then set the subform to data entry, make it a single form view, and format the single form view as a tabular form (i.e. stack the labels on top). Remove the navigation buttons on the subform. You could probably do this with a continous form and some code, but I think you would see the new row but be unable to access it.

 

[TheAceMan1]

How are ya cmmd2003 . . .

From what you've shown, the 2nd record is the [blue]add new record line[/blue]. Set the subforms [blue]Allow Additions[/blue] property to [blue]No[/blue].

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cmmd2003]

However setting the allow additions property to no prevents any records being added at all

 

[TheAceMan1]

cmmd2003 . . .

You could have your own [blue]command button[/blue] reset the property and on saving the record set it back.

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[PHV]

Set the ForeignKey in the child table to unique (ie NOT allowing duplicates).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886