Sub Forms

[fastPace]

I have been using a sub form to accumulate data, however, the data is bound. Is there a way I could do something similar but have the data be unbound until I decide I want to keep it? Kind of like an unbound data grid.

[Rabbit]

Yes one way is to keep the form bound but use unbound controls. Then use a button to populate the record. Another way is to use an unbound form and use a DoCmd.RunSQL to append the data.

[fastPace]

Thanks a bunch. I will try this out!

[fastPace]

I tried using a bound subform with unbound controls and I enter data in the first line of the subform but it won't drop down to the next line. I assume I have so save each record before I can move onto the next.
So I can't use the button to populate multiple records at the same time; is that correct?

[Rabbit]

I tried using a bound subform with unbound controls and I enter data in the first line of the subform but it won't drop down to the next line. I assume I have so save each record before I can move onto the next.
So I can't use the button to populate multiple records at the same time; is that correct?

No, not if you do it that way. You could try using a bound temp table and clear or append those records when they press the button.