recordset cannot be updated problem

ajaymansata

Registered User.
Local time
Today, 08:04
Joined
Dec 17, 2001
Messages
25
Hi
Well i have a problem while updating a query.
I have a table which has the following fields
studid,lastname,sex,country,permanentaddress,permanent number.
Now i create a query from this table say,Query1 in which i have the fields
studid,lastname,sex country with a criteria as country should be equal to USA.
Next i create a query say query2 with fields permanent address,permanent number where studid id equal the ones in query1.
While i try to update the data of query2 i get a message
This recordset is not updateable.
Can you tell me a resaon for this.
 
Search help for "TroubleShoot Select Queries", select "I can't update data..." for more information about when queries are updatable and when they are not.
 

Users who are viewing this thread

Back
Top Bottom