Using recordset clone to display a table in a form

[Nishikawa]

Hi,

I am wondering if this is possible.

I have form A, user select one of the items in the table and click a button "Get details"
The button will get all corresponding details and display it in a subform (let's say form B) using SQL.

Problem is that the SQL locks the recordset since it is being displayed in the subform.

Is it possible to create a recordset.clone from SQL and display it in a subform so that I can still makes change at the backend.

I do not usually user query but with DAO.database and DAO.recordset

 

[boblarson]

Actually it sounds like you may have a design issue if you are storing all of this in a single table. If so, why use more than one form for the data?

 

[Nishikawa]

Hi Bob,

Been a while since you have helped me. Happy to hear from you again.

I do not have an issue with my table, it is just that there is not enough space to display everything in a single row. There is why I need to spilt half of it to a subform.

The details in the subform are meant to be only read only while the details in the mainform can be updated by another person on another computer (My database is a multi user environment).

It is this problem that i need to do a recordset.clone. You have any advice for me?

 

[Nishikawa]

If I do not use recordset.clone, will using dbopensnapshot help me?
I am displaying a lot (and I mean a lot!) of information on a single page(using tabs) I have been using queries and it is taking longer and longer to load.
I am trying to find a way make my application run faster.

 

[boblarson]

I am displaying a lot (and I mean a lot!) of information on a single page(using tabs)

Are these subforms on the tabs or just other fields from the same table on the other tabs?

 

[Nishikawa]

All of the subforms are in different tabs. I used a invisable connector to link the subforms to the main form.

User clicks on one of the rows in the main form. He then clicks "Get details" button. This fires an event that capture the primary key of the selected row and start processing all the subforms (till date, 7 of them) by getting the recordset using SQL and DAO

 

[Nishikawa]

Bob,

Is it possible to use DAO.Querydef to populate a table which is then to be uses in a form? I read that querydef creates a temp query that will not lock the original table.

If that is possible, how do i create the code?

 

[boblarson]

I'm to a point where I would need to actually see the database and what you are doing to see if I can figure out a way to make things work for you.

But, one more thing to check - do you have each of the forms Record Locking property set to NONE?