
Signature
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
>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
[quoted text clipped - 3 lines]
> Can
> you help? The form, created from the query, won't let me enter new data.
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.
> Cheryl,
> When you say "index message" can you be a bit more specific about what that
[quoted text clipped - 8 lines]
> > Can
> > you help? The form, created from the query, won't let me enter new data.
Lynn Trapp - 31 Jan 2005 20:48 GMT
Can you post the SQL statement for the query?

Signature
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
> Well, actually, I figured out how to make the relationship work, but it
> still
[quoted text clipped - 29 lines]
>> > you help? The form, created from the query, won't let me enter new
>> > data.