Unanswered: Re: Why is the subform opens to read-only?
I have a subform base on a table I created in the subform's open event. But the subform is open to read-only.
I set the subform's source object to the tblTemp_inspec it still won't edit. The Problem must be in creating the tblTemp_inspec. But I thought the default setting is read/write and I am not sure how to modify the code.
This is my code:
Public Sub Form_Open(Cancel As Integer)
str = "Create Table tblTmp_inspec(bag_num integer, quantity integer, inspection_type integer, partial bit, complete bit)"
'if a condition is true
'calls stored procedure insert a record in tblTmp_inspec
str = "Select tblTmp_inspec.bag_num,...."
Me.RecordSource = str
I'm using Access2000 and SQL Server BE
The form's lock property is set to 'No'
I just can't understand why is the form is open to read-only.
Thanks for your reply. You're right. There is a problem in updating the records in the view I created in SQL Server.
Would you know what this message means:
Insufficient key column information for updating of refreshing.
The columns I tried updating store bit data type.
These are columns
bag_num(int), quantity(int), desc(char), partial(bit), complete(bit)'
The first three columns are populated thru open event of the subform. The last two columns are check boxes. I don't need them to be saved I just want to be able to check those boxes but these check boxes are not working in the subform. All the fields are bound in the subform.
I just can't understand why these check boxes are not working??