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

Subform - Display Problem

P: n/a
Hello,

I'm using a form that has a subform. The subform is linked to a hidden
datasheet form, and the subform displays records from the form.

The problem is, the subform will only show X number of records, and one
additional record for data entry. My boss wants me to show an entire sheet,
with many rows available for data entry (Because it looks better).

Is there a property that can be changed to show the subform in this way?
This may be an easy one but I'm not familiar enough with subforms to know.

Thanks in advance,

Nick

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Nick via AccessMonster.com wrote:
Hello,

I'm using a form that has a subform. The subform is linked to a hidden
datasheet form, and the subform displays records from the form.

The problem is, the subform will only show X number of records, and one
additional record for data entry. My boss wants me to show an entire sheet,
with many rows available for data entry (Because it looks better).

Is there a property that can be changed to show the subform in this way?
This may be an easy one but I'm not familiar enough with subforms to know.


No, you will always only ever get one blank line for the new record. You
could bodge a workaround whereby you enter some blank records into the
underlying table but...

Pros:
Your boss will think it looks better (questionable)

Cons:
You need to maintain the number of blank records.
You need to maintain some sort order so that the blank ones always
appear last in your subform.
This may impact on a required field.
It's a waste of space.
It's a waste of resources to create just to please your boss in that way
(completing the project on time might be a better way to please him).

You have my express permission to dope slap your boss.

--
[OO=00=OO]
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.