Pat Hartman or anyone Please help with ERROR

[majette97]

Pat below is my code and now I am getting a Runtime Error : 'This Record set is not updatable. Can you help! Thanks!

Set rs2 = CurrentDb.OpenRecordset(strSql)

Forms!change_timecard!change_timecard_sub.Form!txtAppName = AName (Doesn't work)
Me![txtTaskName] = TName
Me![Monday] = rs2![MON]
Me![Tuesday] = rs2![TUE]
Me![Wednesday] = rs2![WED]
Me![Thursday] = rs2![THU]
Me![Friday] = rs2![FRI]

 

[Pat Hartman]

Apparently the query your form is based on is not updateable. Try running the query by itself to make sure.

PS - please don't start new threads for additional questions on the same topic.

[This message has been edited by Pat Hartman (edited 06-26-2001).]

 

[majette97]

I've run/opened the query and it displays the data; how can I tell if it is updatable?

 

[Pat Hartman]

Try to update it. If the >* is grey you can't insert rows but there's no visible way to determine updateability.