help!

I am a new Access user and I'm having the following
problem:
I added three fields to an existing database which are to
include three dates for vaccination of each employee in
the database. However, each time I add a date to any
employee's record, it adds it to EVERY record. Any ideas
on how to fix this?

"Jennie" wrote in message

I am a new Access user and I'm having the following
problem:
I added three fields to an existing database which are to
include three dates for vaccination of each employee in
the database. However, each time I add a date to any
employee's record, it adds it to EVERY record. Any ideas
on how to fix this?

I'm guessing that you add these vaccination-date fields (text boxes) to
the form, not to the table on which the form is based. Thus they would
be "unbound" controls, not bound to any record, and so when you display
the form all records show the same value in that control. But the value
isn't actually being stored anywhere; it's just being displayed.

If I'm right about what's going on, here's what you should do. Press
F11 (if necessary) to display the database window, go to the Tables tab,
open the table the form is based on in Design View, add your
vaccination-date fields (field type Date/Time) to the table, then close
and save the table. Now go to the Forms tab, open your form in Design
View, remove the unbound text boxes you added, then click the "Field
List" button on the toolbar to display the field list of the form's
record source.

If the fields you added to the table aren't there in the list, your
form's Record Source is probably a query or SQL statement, and you'll
have to modify that before you can get the fields onto your form. To do
that, close the field list for now and click the "Properties" button to
bring up the property sheet for the form. Go to the Data tab of the
property sheet and you should see the Record Source property. Click on
that line, then click on the "build" button (caption "...") that will
appear at the end of the line. Modify the query to include the fields
you added to the table, then close it and let your changes be saved.
Now click the "Field List" toolbar button again, and the new fields
should be displayed. (If they aren't, close and save the form, then
open it again in Design View).

From the field list, drag the new fields down to the body of your form
and drop them where you want them. Make any formatting changes you
want, flipping into Form View if you'd like to see what the form looks
like, then save your changes and close the form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)