By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,310 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,310 IT Pros & Developers. It's quick & easy.

Manage form + subform as a single record

P: n/a
max
Hi all,
I have a problem that maybe has no solution, but before giving up, I was
wondering if somebody has an idea....
I have a form with a subform (continous) that shows the related records; the
form shows the CDs, while the subform shows a record for each item in the
CD.
Pressing the Edit button, the form and the subform become editable, so that
the user can change the CD details and / or any information about the
content. After having done any change, I've put an undo and a save button so
that the user can decide wheter confirm the changes, or discard them.
As you can image, the save button works anyway (it is almost a fake button
cause access saves automatically) while the undo button often doesn't work,
cause as soon as you click in the subform, the record on the form is saved,
and if the user moves accross several records in the subform and makes
several changes, the undo button will not work for all of them...
Is there a big mistakes somewhere or is it just not possible? Any other
idea?
For us who know what a record and a table are, it is easy to know when to
use save or undo, but for a user that is just doing data entry and doesn't
know anything about Access, would be great to look at form and subform like
a unique record.

Any help or ideas very much appreciated,

Massimo

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sun, 23 May 2004 21:24:50 GMT, "max" <a@b.net> wrote:

It's just not possible, unless you go to extremes such as unbound
forms or bound forms that write to a "temp" table. Typically this is
just not worth it. Rather teach users to observe the record selector,
and know the difference between a pencil and a triangle.

-Tom.

Hi all,
I have a problem that maybe has no solution, but before giving up, I was
wondering if somebody has an idea....
I have a form with a subform (continous) that shows the related records; the
form shows the CDs, while the subform shows a record for each item in the
CD.
Pressing the Edit button, the form and the subform become editable, so that
the user can change the CD details and / or any information about the
content. After having done any change, I've put an undo and a save button so
that the user can decide wheter confirm the changes, or discard them.
As you can image, the save button works anyway (it is almost a fake button
cause access saves automatically) while the undo button often doesn't work,
cause as soon as you click in the subform, the record on the form is saved,
and if the user moves accross several records in the subform and makes
several changes, the undo button will not work for all of them...
Is there a big mistakes somewhere or is it just not possible? Any other
idea?
For us who know what a record and a table are, it is easy to know when to
use save or undo, but for a user that is just doing data entry and doesn't
know anything about Access, would be great to look at form and subform like
a unique record.

Any help or ideas very much appreciated,

Massimo


Nov 13 '05 #2

P: n/a
max

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:nh********************************@4ax.com...
On Sun, 23 May 2004 21:24:50 GMT, "max" <a@b.net> wrote:

It's just not possible, unless you go to extremes such as unbound
forms or bound forms that write to a "temp" table. Typically this is
just not worth it. Rather teach users to observe the record selector,
and know the difference between a pencil and a triangle.

.... Yes, I think so... thanks Tom for confirmation :)
Cheers
Massimo
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.