3 Problems getting forms to work

New to Access...I've created 2 tables, one is an address book of Dealers, the
other is a warranty file of products. There is a one-to-many relationship
using a 4 letter dealer code between the two. When creating a simple form
from fields in both tables, I have no problem, but when I start customizing,
i.e., changing text boxes to combo boxes, I run into trouble.
Basically, there are 3 issues with the forms. 1 - I cannot enter data into
a new form, but am able to modify the existing forms. 2 - I can enter data
into all but one field on a new form. 3 - I can enter info into a new form,
but it won't save to the table.
My relationships are set up to allow cascading updates and my forms are
enabled.
Sorry this is so long. Any help is greatly appreciated.
Karen

Hi Karen,

1. If you cannot add new records, check that your query behind the form is
updateable (and allows new records). If you have joined multiple tables in a
query and don't have a valid PK/FK pairing, the query will not be updateable.

2. What happens when you attempt to enter data into that one field? Is the
field bound to a field in your database?

3. Are the fields on your new form bound to fields in your database.

As an aside, if you have one-many relationships, you can achieve this nicely
by having the data from the 1 side in a main form, with a subform for the
many side, and Access will take care of the relationships for you (assuming
you have set them in the relationship manager).

Hope this helps.

Damian.

"KB" wrote:

New to Access...I've created 2 tables, one is an address book of Dealers, the
other is a warranty file of products. There is a one-to-many relationship
using a 4 letter dealer code between the two. When creating a simple form
from fields in both tables, I have no problem, but when I start customizing,
i.e., changing text boxes to combo boxes, I run into trouble.
Basically, there are 3 issues with the forms. 1 - I cannot enter data into
a new form, but am able to modify the existing forms. 2 - I can enter data
into all but one field on a new form. 3 - I can enter info into a new form,
but it won't save to the table.
My relationships are set up to allow cascading updates and my forms are
enabled.
Sorry this is so long. Any help is greatly appreciated.
Karen

Hi Damian,

Thanks for your response.

Point 1.
I don't have a query behind the form. The form is based on a dealer table
and a warranty table where the common field is the dealer code. In the
dealer table the dealer code is the primary key. In the warranty table the
dealer code is a foreign key. When creating relationships between the 2,
I've enforced referential integrity and allowed updates, but not deletions.

Point 2.
When I attempt to enter data into the form and cannot, I find I'm able to
put my cursor into the field, but when I use the keyboard, I get one little
"ding" type sound and nothing else happens. Just a little "ding" for every
keystroke I make. And yes, the field is bound to a field in my database.

Point 3.
Since I used the wizard to create my form, the fields are definately bound
to the fields in my tables.

I've been too busy at work today to spend any time on this problem.
Hopefully, tomorrow will be quieter and I can ruminate!

Any ideas?

Thanks,
Karen
--
Karen


"Damian S" wrote:

Hi Karen,

1. If you cannot add new records, check that your query behind the form is
updateable (and allows new records). If you have joined multiple tables in a
query and don't have a valid PK/FK pairing, the query will not be updateable.

2. What happens when you attempt to enter data into that one field? Is the
field bound to a field in your database?

3. Are the fields on your new form bound to fields in your database.

As an aside, if you have one-many relationships, you can achieve this nicely
by having the data from the 1 side in a main form, with a subform for the
many side, and Access will take care of the relationships for you (assuming
you have set them in the relationship manager).

Hope this helps.

Damian.

"KB" wrote:

New to Access...I've created 2 tables, one is an address book of Dealers, the
other is a warranty file of products. There is a one-to-many relationship
using a 4 letter dealer code between the two. When creating a simple form
from fields in both tables, I have no problem, but when I start customizing,
i.e., changing text boxes to combo boxes, I run into trouble.
Basically, there are 3 issues with the forms. 1 - I cannot enter data into
a new form, but am able to modify the existing forms. 2 - I can enter data
into all but one field on a new form. 3 - I can enter info into a new form,
but it won't save to the table.
My relationships are set up to allow cascading updates and my forms are
enabled.
Sorry this is so long. Any help is greatly appreciated.
Karen