Edit records in a from while they are opened in another form

[nadoona]

Hi,
I've a search form that lets the user search in the Orders. It consists of some combo and text boxes and a SubFrm (whose the record source is a query).
The SubFrm is a continuous form. I've added a button to appear in each record (order). This button opens another form that contains all the information of that Order.
But the problem is that I can't edit anything in the Order (I think because it's already opened in the Search form). So, I'm wondering if there is a way that lets the user edit the Orders keeping the same strategy of opening them (searching in a form, then clicking on the button to open the details).

Please advise.
Thanks.

 

[Pat Hartman]

Having another form open with the same record won't prevent you from updating the record. When you try to save the record, you'll get a message if the first form saved changes between the time you opened the second form and when you tried to save changes to the second form.

Check your form's properties and also check the form's RecordSource query to see which is causing the problem. You should also fix the first form so that it returns a snapshot rather than a dynaset. Since you will not be updating with the first form there is no reason to have an accidental confilct.

 

[nadoona]

Ok,
Thanks a lot "Pat Hartman".