Continuous sub-form limited to one line

[UTS]

Using Access 2010 32



Got a form with an "add" button, and a continuous subform, with one unbound text box. The text box value is passed to a table via VBA when the "add" button is clicked. This works perfectly.

However, the subform is limited to one line only, although "allow Additions" and "allow edits" is set true.

(This is a much more elaborate form/subform but I have reduced it down to just the add button and the text box while troubleshooting this problem)

Any ideas?

Cheers,
Brodie

[CJ_London]

you also have to have data entry set to false

[UTS]

It is.

Cheers

[CJ_London]

sounds in that case like your form is unbound or the recordsource is not returning any records.

[UTS]

That's right. All the values on the form and sub-form are "INSERTed INTO" a table on the "ADD" button press. It all works fine, except for the sub-form only showing one line. Pictures above shows the sub-form. Notice there should be a new line there.

BTW, the sub-form on its own behaves the same i.e. only showing one line. So problem is with sub-form I believe. But what??

Cheers,

[CJ_London]

All the values on the form and sub-form are "INSERTed INTO" a table on the "ADD" button press

yes, I saw that but your form could still have been bound to a temporary table

it is because your form is not bound - it can only show multiple rows if there are multiple records

good luck with your project, but I don't think I can help you

[ssanfu]

I agree with Ajax...

<snip>it is because your form is not bound - it can only show multiple rows if there are multiple records

You say "All the values on the form and sub-form are "INSERTed INTO" a table on the "ADD" button press".
If that is so, why isn't the sub form bound to that table??

It is much, much easier to use a bound form than executing code to append records......

[Missinglinq]

In point of fact, an Unbound Form doesn't display any Records at all...how could it...it's not connected, directly or indirectly (through a Query,) to a Table, and that's where Records reside!

An Unbound Form can only hold data that has been entered into the Form's Controls...not Records. You can then use SQL, as you're doing, to insert that data into a Table/Record, but you can only do so one set of data at a time.

A Bound Form is really the way to go, as it is about 99% of the time, in Access.

Linq ;0)>

[UTS]

OK, Gotcha. Working fine now.

Thanks a lot.

Cheers,