Form won't stop "Calculating" with two subforms linked to mainform

[Guest]

Hello,

I'm having a little bit of a problem, I have a form for transactions by
customers(frmCustomerTransactions), and a subform
(frmCustomersTransactionsDetail) with each transaction on page on of a tab
control. On page two I have two more subforms (frmTransactionServices,
frmTransactionProducts) one for services for the transaction and one for
products for the transaction. I have an invisible text box
(CurrentTransactionID) on frmCustomerTransactions linked to the TransactionID
in frmCustomersTransactionDetail which I use as the Master Control for both
frmTransactionServices, and frmTransactionProducts, and both forms use their
TransactionID field as the child. The problem is that when I have both of
these subforms linked to this CurrentTransactionID the main form continuosly
calulates, if only one is linked it displays just fine though. Any ideas how
to fix this?

Thanks a lot!

Adam

 

[strive4peace]

Hi Adam,

make CurrentTransactionID an unbound control on the main form

in the OnCurrent event of the mainform

me.CurrentTransactionID =
nz(me.frmCustomersTransactionsDetail.form.TransactionID,0)


and the OnCurrent eventand AfterUpdate event of
frmCustomersTransactionsDetail

me.parent.CurrentTransactionID = me.TransactionID


you may also need to requery the two other subforms that
depend on it - don't do it unless you need to

this may not be what is causing the "calculated" message ...
do you have any combos or listboxes with references to form
controls?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Hello,

I'm having a little bit of a problem, I have a form for

transactions by customers(frmCustomerTransactions)


, and a subform (frmCustomersTransactionsDetail)


with each transaction on page on of a tab control. On
page two I have two more subforms (

frmTransactionServices,
frmTransactionProducts


one for services for the transaction and one for products
for the transaction.

I have an invisible text box CurrentTransactionID) on
frmCustomerTransactions linked to the TransactionID