Can update from query, but not from form?

[Brian_45]

Alright, this has me stumped. Here we go...

I have a form that if I open it from the main switchboard, I can edit the records fine, but if I open it from a search form the record is not updateable (the form is filtered. But unfilitering the form doesn't help). AllowEdits is set to true on the form.

The form does use a query for it's data, but the recordset is perfectly updateable from within the query.

Here is the code I am using to open the form from the search grid:

Private Sub SalesOrder_Click()
[Forms]![SearchTrResults].[SalesOrder] = Me.SalesOrder.Value


DoCmd.OpenForm "JobsForm", , , "SalesOrder = Forms!SearchTrResults.SalesOrder"
DoCmd.Close acForm, "SearchTrResults"
End Sub

I have the recordset type set to Dynaset (inconsistent updates) in both the form and query.

There are no linked tables involved in the query and the query is merely calling all of the fields from a particular table. Here is the query:

SELECT tblJobs.*
FROM tblJobs
ORDER BY tblJobs.Status DESC , tblJobs.PeriodStartDate DESC;

I actually have two forms doing this, but the problem has to be the same because the circumstances are identical.

This is driving me nuts. Please help!

Thanks,

Brian

[Brian_45]

Changed the OpenForm code a bit and still no worky

Private Sub SalesOrder_Click()
[Forms]![SearchTrResults].[SalesOrder] = Me.SalesOrder.Value
DoCmd.OpenForm "JobsForm", acNormal, , "SalesOrder = Forms!SearchTrResults.SalesOrder", acFormEdit
DoCmd.Close acForm, "SearchTrResults"
End Sub

[Brian_45]

I figured it out!

I had the search grid set with record locks to all records. That was apparently carrying over to the jobs form even after the search form was closed. Weird, but it's fixed!

Hopefully this post will help out some poor frustrated soul in the future!