My form won't let me enter new records

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

Guest

I am very new to access, and am creating an address database. I'm tying to
create a pretty simple table for the contacts, and another table with zip
codes, cities and states. When I try to create a relationship between the 2
tables, to create a form to enter the data, it gives me an index message. Can
you help? The form, created from the query, won't let me enter new data.
 
Cheryl,
When you say "index message" can you be a bit more specific about what that
is? Also, could you paste the table structure for your two tables and what
the recordsources is for your form.
 
Well, actually, I figured out how to make the relationship work, but it still
won't let me input new data into a form that I created from a query with both
tables included in the query. I created 2 tables, one for the contacts, and
one for the zip code. The zip code one only has 3 fields, (zip, city and
state). The contact table has 31 fields. I created a query, sorting the last
and first names, using both tables, and created a form from that "alpha
query". I've gotten the tabs to cooperate (skipping over the city and state),
but the form will not allow me to enter a new record.
 
Back
Top