No Blank Form

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000
I have two tables with one Db. One table has customer
information that was copied from another Db. The second
table has other information on it regarding phone sales
phone calls. Both tables are joined by the telephone
number.

I can not get the form to give me a blank copy. It will
only bring up completed forms that were done before in
another Db.

I don't where to look for the problem. Can anyone help
me??

Aurora
 
What you have is a non-updateable recordset. This can happen in a number of
ways in Access, but it is likely that in neither of your tables has a Unique
Index on the phone number. In order to be updateable, the JOIN field in ONE
of the tables MUST be the Primary Key or have a Unique Index .
 
Roger:
THANK YOU -- THANK YOU -- THANK YOU VERY MUCH.
You were right. I went back to the Cust Table and found I
had forgotten to make the tele number non duplicatable.
When I did this, I found that the table had at least 12
records that were duplicates. Once I corrected this, the
form works just find.

I knew that, but when I am working on a Db that someone
else has created, I sometimes forget to check the little
things.

Again, Thank you very much.

I need to post another message about copying information
from a form to a table. If you could answer this for me I
would appreciate it.

Aurora
 
Back
Top