Is subfrom data entry possible?

  • Thread starter Thread starter Reli
  • Start date Start date
R

Reli

Hello All!

Please help me figure this out. I am new to Access & I
have this problem:

I have a main form: contact name, address, etc.
My subform is a mailer tracking subform: shopping center
name (30 names), date mailer sent, comments

On my subform: I want to be able to enter data on "date
mailer sent" for any "shopping center name" depending on
mailers sent out.

But, everytime I enter data on my subform, it is also
reflected on all my contact names. I want each contact
name to have its own mailer tracking.

How do I do this? I tried linkchild-linkmaster step, but I
need my subform to show all the "shopping center names" so
I could do the "date mailer sent" entry.

Thanks
 
I have a main form: contact name, address, etc.
My subform is a mailer tracking subform: shopping center
name (30 names), date mailer sent, comments
Click to expand...

Stop. You're on the wrong track!

A Form DOES NOT CONTAIN ANY DATA. A Form is *just a window*, a tool to
display and work with data; the data resides in your Tables, and only
in your Tables. You're installing the windows of your house before
you've poured the foundation!

What is the structure of your Tables? What are the Recordsource
properties of your two forms?
 
Thanks John!

I do have 2 tables. my contact table is ok. I have been
using it for a year or so. It is a working database of
which I have entered data. My problem arose whenI tried to
make a subform so I can keep track of mailers sent out for
each contact per shopping center

My problem is to make my subform work. My recordsource for
my subform is my mailer table.

my subform table contains the ff:
ID
shopping center name (30 names)
date mailer sent (data entry req depending on mailer sent)
yes (data entry required depending on who said yes)
no (data entry req depending on who said no)
comments (data entry req, as needed)

How can i make these entries on my subform table (mailer)
so that it will reflect he mailer activity per contact?
-----Original Message-----
Click to expand...
 
Thanks John!

I do have 2 tables. my contact table is ok. I have been
using it for a year or so. It is a working database of
which I have entered data. My problem arose whenI tried to
make a subform so I can keep track of mailers sent out for
each contact per shopping center

My problem is to make my subform work. My recordsource for
my subform is my mailer table.

my subform table contains the ff:
ID
shopping center name (30 names)
Click to expand...

Is this *thirty fields*, each with a name? or a field which can have
your choice of any one of thirty names?
date mailer sent (data entry req depending on mailer sent)
Click to expand...

Date mailer sent - but is there a field identifying which mailer was
sent? I still think you have a MANY TO MANY relationship, and you're
only modeling a one to many. What is the real-life relationship
between Contacts, Shopping Centers, and Mailings? Surely each Center
can get several mailings?
yes (data entry required depending on who said yes)
no (data entry req depending on who said no)
comments (data entry req, as needed)

How can i make these entries on my subform table (mailer)
so that it will reflect he mailer activity per contact?
Click to expand...

With a correct table design... which I suspect you do not yet have!
 
Back
Top