Duplicating date in a tet box on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 7 contacts listed on it and I need to add a field for each
contact for a date and mailout number. My problem is that I have added the
date and mailout number field to each contact and when I go to enter the date
or a number for the mailout, it goes into every field for all 7 contacts.

I have not designed the database or form, I have been asked to modify it and
I only have limited knowledge of Access. I am also required to use this form
and not design another one.

Can someone please help me solve this problem so that when I enter the date
or a mailout number it is only in the box I enter it into.

Thanks
Tal
 
what you're working with are *controls* on a form. data is not saved in
forms, it's saved in tables. if you want to enter data that is specific to
each contact, you must start by adding date and mailout number fields *in
the table* that underlies the form (if those fields do not already exist in
the table). then, in the form design view, set the ControlSource property of
those two controls to the corresponding fields in the table.

hth
 
Back
Top