Hello,
I am using a continuous form for data entry, and every time I tab out of one record, a new one is created automatically and shows up underneath the first one. The reason for this setup is so that users can add information into a child table, but the number of entries that are added per parent-table record varies and cannot be determined beforehand. This seemed the easiest method, and the data is properly stored in the table.
The subform has an etched border and a background colour that's different from the underlying main form.
I would really like to have the subform expand down every time a new record is added, instead of making it large enough beforehand so that it can hold/display several records which may or may not be created.
I noticed that there was a property that supposedly lets the form grow automatically, but that doesn't seem to have any effect.
Is there a way to achieve my goal, and how would I go about it?
Thank you.
I am using a continuous form for data entry, and every time I tab out of one record, a new one is created automatically and shows up underneath the first one. The reason for this setup is so that users can add information into a child table, but the number of entries that are added per parent-table record varies and cannot be determined beforehand. This seemed the easiest method, and the data is properly stored in the table.
The subform has an etched border and a background colour that's different from the underlying main form.
I would really like to have the subform expand down every time a new record is added, instead of making it large enough beforehand so that it can hold/display several records which may or may not be created.
I noticed that there was a property that supposedly lets the form grow automatically, but that doesn't seem to have any effect.
Is there a way to achieve my goal, and how would I go about it?
Thank you.
