By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Suppress Row of Empty Fields in SubForm

P: 1
I need to hide/not display 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. Before records are added is not a problem,it's when
records are added that the row of empty fields is a pain. It actually looks like a "New Record Row"

Any ideas appreciated, cheers

I've tried CanShrink etc,
Jul 27 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
If I understand well you want that the row with thenew record doesn't appear, do-I? If Yes, you have to go to the Form properties and change the property allow additions to No
Aug 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.