undoing subforms

[Guest]

hello,

Im making a database to store information for a student housing company
which stores data about rooms, students and payments etc.
Ive been struggleing on this payments form for over a week now and its on
its 4th iteration!!

The problem is that the form is either based on a complex multitable query
or it has the main table as the main form and the other tables as subforms.

The main table is called Payment and has simple information about the
PaymentNo(PK) and the student who is making a payment, details of the payment
are collected through subforms which correspond to different tables. So
there is a subform for rent, parking, telephone etc. each table has
different data but they all have a 'PaymentNo' foreignKey field and a
'StudentRef' foreignkey field.
each subform has a tick box which is used to enable the controls on that
subform and import in this information from the main form to create a new
record in the subform's table.

what i need to be able to do is undo this record so that its not saved when
the form is saved.

If that was hard to follow ill happily post up my sql code and clarify any
other things involved with this.

with thanks and regards

Amit

 

[Rick Brandt]

hello,

Im making a database to store information for a student housing
company which stores data about rooms, students and payments etc.
Ive been struggleing on this payments form for over a week now and
its on its 4th iteration!!

The problem is that the form is either based on a complex multitable
query or it has the main table as the main form and the other tables
as subforms.

The main table is called Payment and has simple information about the
PaymentNo(PK) and the student who is making a payment, details of the
payment are collected through subforms which correspond to different
tables. So there is a subform for rent, parking, telephone etc. each
table has different data but they all have a 'PaymentNo' foreignKey
field and a 'StudentRef' foreignkey field.
each subform has a tick box which is used to enable the controls on
that subform and import in this information from the main form to
create a new record in the subform's table.

what i need to be able to do is undo this record so that its not
saved when the form is saved.

Why?

Implementing a web-like thin client interface where nothing permanent
happens to the data until some sort of button is pushed is difficult to
implement in Access any time subforms are involved. The most practical
apprach is to bind the forms to work tables when editing and then use
Insert, Update, and Delete queries to propogate the changes to the live
tables when the button is pushed.

Much more practical is to simply teach your users how Access works and tell
them that changes are changes and if they don't want to make changes then
DON'T.