Suppress/Hide blank row in a Subform

[shaggers]

I need to suppress/hide a blank row on a subform.
The Main form is based on a table, contains Site Header information
The Subform is based on another table containing Sample Details records

Site Header table to Sample Details table relation ship is one-to-many,
with two key fields SiteID and SiteVisitDate

The Form/SubForm is linked by SiteID, SiteVisitDate

The form adds one record to the Site Header Table.
Then adds mutliple records to the Sample Details table for that SiteID.
Some fields are populated with a script, while others are populated by user input

An empty/blank/new row always appears on the subform before & after the Sample Details are added. The blank row Before new records are added is not a problem but when it appears after new records are added is a pain

I've tried CanShrink etc,

Any help appreciated

Cheers,
Michael

 

[MStef]

Is it a big pain ????

 

[shaggers]

yes, key fields are automatically populated and is a user enters anything into any fields in the blank row, it is a pain

 

[MStef]

If it is a big pain, take sam medicine, if it is not so big forget it.

 

[MStef]

Try with VISIBLE properties (No).

 

[Carl Foster]

In the form properties there is one called "allow additions". Set that to "No" and that should disappear.

 

[shaggers]

Setting "Allow Additions" to No seems to have fixed the problem, no more pain.

I tried setting Visible to No, all variations thereof, didnt work


Thanks