data not stored in tables

[Guest]

I have a form that's based off a query with 3 tables related to each other by
one unique field. -- I have several fields on the form that need employees
initials to be typed in by the user and several check boxes for users to
choose different options. This information is not being stored in the
underlying tables and is not unique to the form #. (i.e. If I type an
emplyees' initials in a box it appears on all the forms....if I check a box
on one form it appears on all the forms)
Plz. help!

Ruth

 

[Rick Brandt]

I have a form that's based off a query with 3 tables related to each other by
one unique field. -- I have several fields on the form that need employees
initials to be typed in by the user and several check boxes for users to
choose different options. This information is not being stored in the
underlying tables and is not unique to the form #. (i.e. If I type an
emplyees' initials in a box it appears on all the forms....if I check a box
on one form it appears on all the forms)
Plz. help!

Sounds like the controls are not "bound" to the fields in the RecordSet. They
should have the name of the field where you want the data saved entered in their
ControlSource property.

Beware that many multi-table queries are not updateable so even when you fix
this first problem it might not work. Try opening the query directly and see if
you can make edits.