Carmen,
>David, I have tried this out, It works but It doesnt come in front of the screen
>it still stay at the back even i called it twice.Are you sure you don't have Form2 set as AlwaysOnTop = .t.? Can you bring form1 on top by clicking it with the mouse? Did you step through the code in the debugger and see if the search loop was finding it? It was written to look for the form by it's .Name value.
> I tried to edit the record or add record. It come out the message 'cannot access the table'It sounds like you have one of your forms closing the tables that the other form is using. What .DataSession are on your forms?