Unbound Continuous Forms

J

Justin

Hi,

I'm currently developing a access project connecting to a sql server. I am
attempting to populate a continuous form based on a stored procedure
recordset. I've managed to populate the form with data but when i try to
change the client data i get the error message: 'Field X based on an
expression can can't be edited'. this occurs even though i'm only trying to
alter the data on the form. Anyone got any ideas how i can change the loaded
form data?

Thanks,
Justin.

Code:
Form_Load()
Dim objConn As Connection
Dim rst As Recordset

Set objConn = CurrentProject.Connection
Set rst = New Recordset

'load object data
rst.Open "up_select_episode_week_scheduling", objConn, adOpenDynamic,
adLockReadOnly, adCmdStoredProc

Set Form_frm_Weeks.Recordset = rst

With Form_frm_Weeks
.txt_week_id.ControlSource = "Week_ID"
.cbo_Episode_Group.ControlSource = "Episode_Grouping_IN"
.cbo_Unit.ControlSource = "Unit_IN"
.cbo_Week_Beginning.ControlSource = "Week_Beginning_IN"
End With

rst.Close
Set rst = Nothing
 
Top