Frequent error in Referring/linking a textbox in subform from textbox within mainform

[tim_tims33]

Hi,
I've been working with simple invoice systems for a while now, and i can get them to work ok. A frustrating problem arises now and again that I can't understand why.

I've attached an example to help me explain (see attachment)

Go to frmInvoice, and you'll see a Net Total box (txtNetTotal) . It's control source is linked to a textbox in the subform fsubInvoiceDetails2 called txtStocktotal. It basically just pulls up all the costs associated with that InvoiceID.



The reference mechanism is as follows: =[fsubInvoiceDetails2].[Form]![txtStockTotal]

Now...sometimes this works and sometimes it doesn't! Sometimes i've had to use: =forms!fsubInvoiceDetails2!txtStockTotal.

It seems to be very temperamental at times and i'm not fully confident if this can be explained.

By way of note, I use express builder normally to input these statements: I go to Forms > ALL FORMS > fsubInvoiceDetails2 > txtstocktotal.

Am I loosing it?

[ssanfu]

It seemed to update for me.... You might read this site about referencing main forms and subforms:
http://access.mvps.org/access/forms/frm0031.htm

------------------------
I noticed you don't have name autocorrect (aka auto-corrupt) turned off - see http://allenbrowne.com/bug-03.html

It appears you are using autonumbers in the customer, invoice and stock tables as identification (you are displaying them on the forms). This is not a good idea.

See
http://access.mvps.org/access/general/gen0025.htm
http://www.utteraccess.com/wiki/index.php/Autonumbers
http://www.utteraccess.com/forum/Aut...t-t443604.html

Good luck with your project..

[tim_tims33]

Hmm...this is very interesting. Thanks for this Ssanfu