I cannot add records to my database!?!?!?!?!?!?!?

[ScottWood]

When i try to add data to a record i get the error message:
Cannot add records; join key of table 'Colleagues RWL' not in recordset, or edit a record. There are two tables that the data is coming from and they are linked together. There is a query that is bringing the data into the form. Some one please help as i have to change the data using the tables instead of the forms!?!?!?!?

 

[Mze]

Hi,
There are two possible methods that I know of solving this!Firstly make sure when u make the relationship that u select the correct Join type.Alternatively u can open the form in the Design View,open the Form properties and set Record Type to Dynaset....

I hope it helps...
Mze

 

[Garridon]

Another possibility is that if you're using a combo box that might be the source of the problem. I used the wrong field--in my case, the primary key for the table the combo box info was coming from--and it gave me a join error. Wouldn't let me add any records.

I had in the query:

lngOversightID (Primary Key)>tblOversight

I should have had:

lngOversightID (foreign key)>tblTasks.

If it is a join error, delete the combo box and run the wizard again, this time storing the information the foreign key field.

Linda Adams (Garridon@aol.com)
"Promoting Your Club Web site," published in The Toastmaster, June 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com

 

[ScottWood]

I dont seem to have that problem any more but with come control boxes if i try to enter or amend data i get told that the recordset not updateable. It only seems to do it on certain control boxes. The form properties are already set to dynaset, and the relation ship is one to many, and the join properties are set to option 1.

thanks for the help