Can't edit new form while updating main form?

[jetspin]

Hi.

I cannot enter data on a popup form if the main form is being edited (pencil is displayed at left). In other words, the popup form opens and displays but I cannot enter any data in the fields with no messages etc. as long as the main form is being edited. U have to update the main form first. This is an incovenince to the user. I have the pop up form simply to display more addtional data of the same record as the main form.

Some back gound is ...
I have a main form with a button that opens a new small form that has its own query for a control source to the same record of the main form. Here is the code of the button...

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmOrderItems"
stLinkCriteria = "[ordOrdID]=" & Me![ordOrdID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Any ideas?
Thanks

 

[WildHare]

If you think about it, this is perfectly reasonable. Access does not want another edit being carried out (i.e. on the popup form) of a record being edited in another object (i.e. the main form). So you must either cancel or commit the edit of the record on the main form, before you can open it for editing with the popup form.

In the good old days, we used to call this a "deadly embrace"..two processes, each fighting over a transaction.

There probably is no reasonably straightforward way to get around this. What kind of extra data is being edited in the popup form? Is it feasible to store this in another table (Mild violation of normalization rules, but in the interests of system functionality, they can be bent...)

??

Jim

If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[jetspin]

Hi.

Your answer sounds logical. Its just additional data. If I made another table it would be one-to-one... Its normalized data. The main form is a query from a few tables of order, and clients etc., the main one being an order table. This additinal data is just a 'ship list' for the shipper to 'check off' some standard items we ship with every order...

I guess an alternate would be to 'squeeze' the data onto the main form.

Thanks.......