Expand subform when adding records

[Jimcb8]

I have a subform that contains two fields, date visited, # members in family
I can add a new date visited and # in family entries,
if I have the enough space defined for the subfrom, on the main form.
When I reach the end of the defined subform space on the main form, I can't add any more data?
Being a new user, I thought that the first entry would move up and no longer be displayed, to make room for the new entry. That is not the case, it just does not allow me to enter anymore data
Is there some way to to fix this problem?

Thanks so much,

Jim

 

[AccessMSSQL]

It sounds like you don't have scrollbars set up on the subform. Is the subform bound to it's own table? In subform properties - set scrollbars=Both.

http://www.accessmssql.com/

 

[Jimcb8]

the subform does have scrollbars = Both
When I look at the properties of the main form in the subform area it does not show a scrollbar entry other than scrollbar align which is set to system
The data for the subform comes from a query that I wrote and displays all subform entries wih a matching ID from the main form(like a customer master file)
If I physcial inrese the are for the subform on the main form it work just fine.
I'm not sure what other info you need to help me
Any ideas?
Thanks,
Jim

 

[Jimcb8]

When I look at the main form and look at the subform area in design view I do not see any scroll bars??? But the subform does in fact define them. Perhaps I did not design the main for correctly to contain the subform?

 

[Jimcb8]

It seems that scroll bars only appear on the form when the are needed. What I mean is, once I added enough records in the subform, the scroll bars then appear, because they are now needed. I am programming in Access 2010.

Can anyone confirm this guess?

Thanks

JIm

 

[AccessMSSQL]

Yes the scroll bars won't appear unless you need them. So if you have multiple records that go behond the subform you should be able to scroll down and add new records - is your subform set up as a datasheet?

 

[Jimcb8]

Yes it is set up as a datasheet and now seems to be working just fine.

Thank you so much I really appreciate all your help.

I put up a new post regarding an issue with dup dates maybe you could give me your thoughts on that issue

Again Thank you much

Jim