Cant edit Record on Form

[hullstorage]

I have a form with a subform that displays search results from the main form and a button to the side of each record displayed that when i click on the button it opens another form that shows me the full details of the records

the problem i have is when it shows me the record with all the details i cannot change any details

error cannot update due to recordset
so then i created a function where it closed the main form
now i get table " is read only

any ideas

thanks

 

[RuralGuy]

Are you using queries as the RecordSource for each form? You should be.

 

[hullstorage]

Are you using queries as the RecordSource for each form? You should be.

Thanks for you reply

Main Form = Not based on anything
ResultsSubform (within Main Form )= recordscource is a query based on field value from main form fields i.e. JOBId, Customer, Town etc..

Edit Record Form=Seperate Query used from subform field value i.e. JOBId

So when i open main form this has a ResultsSubform and when i click on search button on main form this then updates ResultsSubform

when results are displayed in subform, i click on a button within subform
that then opens another query based form that displays full details of the record for JOBID

Hope this explains a bit
something simple i think but can't quite work it out

 

[RuralGuy]

Is your full details form based on a query that is updateable?
http://allenbrowne.com/ser-61.html

 

[hullstorage]

Is your full details form based on a query that is updateable?
http://allenbrowne.com/ser-61.html

no it is a query with this under the JOBId Field
Criteria = [Forms]![fd]![fdsubform]![jobno]

which looks up the JOBId in the subform

I can edit the record if i enter the JOBId manually
so think the problem is something to do with subform because
when i open from subform it finds and opens the edit form fine
but just wont let me change details

it now says that the recordset is not updateable
in the status bar

 

[RuralGuy]

See if THIS LINK helps a bit.