How do I set up MainForm/Subform as an unbounded field?

[Jrb via AccessMonster.com]

Hello to everyone,

I want to have a MainForm/Subform(Continous Form) to be an unbounded and end-
user will enters all the data and when clicking the 'Save Button', all the
information will be saved.

I did a project in MSACCESS 2003 with MainForm/Subform but the subform was
set a recordsource bound to the table and all the form fields are bounded too.
My problem is when an end-user enters all data in subform, of course the data
is already saved and when he closes the form, only the table bound to the
subform has the data while the mainform has none because all the form field
was unbounded.

I solved this by not allowing the user to close the form until he click the
Save Button and saves all the data from Mainform(unbounded) and there has
nothing to save in subform since it was bounded. I used the recordset method
to write the data in my Mainform recordsource table.

Is there a way we can set both Mainform/Subform to unbounded and use a
mechanism to save all the data in both forms using a recordset method? How
about retrieving the data to both unbounded forms?

Thanks for your help. I really appreciate it!!!


Jrb

 

[Rick Brandt]

Jrb via AccessMonster.com wrote:
[snip]

Is there a way we can set both Mainform/Subform to unbounded and use a
mechanism to save all the data in both forms using a recordset
method? How about retrieving the data to both unbounded forms?

Thanks for your help. I really appreciate it!!!

The main form can be unbound, but a multi-record subform must be bound to a
table. You could use a work table and then in code copy the data to the
final tables when your [Save] button was pressed.

 

[Jrb via AccessMonster.com]

Hi Rick,

Thanks for your advice. Actually, that is my original plan to follow your
advice but I realize, it seems not logical to copy the data to the original
table where the data already been written in the details table (Subform). I
just thought that Subform fields can be set to unbounded.

I really appreciate your advice...

Jrb

 

[Rick Brandt]

Hi Rick,

Thanks for your advice. Actually, that is my original plan to follow
your advice but I realize, it seems not logical to copy the data to
the original table where the data already been written in the details
table (Subform). I just thought that Subform fields can be set to
unbounded.

I really appreciate your advice...

You can probably have a subform that is unbound, Just not a continuous subform.
It is the rows in the RecordSource that determine how many records are shown in
a continuous form and when the form is unbound you would never see more than one
set of controls for a single record.