View Full Version : Pat Hartman or anyone Please help with ERROR


majette97
06-26-2001, 11:04 AM
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!txt AppName = 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
06-26-2001, 04:43 PM
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
06-27-2001, 05:28 AM
I've run/opened the query and it displays the data; how can I tell if it is updatable?

Pat Hartman
06-27-2001, 10:17 AM
Try to update it. If the >* is grey you can't insert rows but there's no visible way to determine updateability.