Re: [Access VBA Central] Calculated Field Not Showing Values

 

You can try to put that calculation on form_oncurrent like this:
Me.text1=DLookUp("StockBal","qryStockBalance","MatCode=" & forms!frmMaterialsProfile!frmMaterialsProfileSub.form.MatCode)
Me.repaint 'If necessary


Samuel Surya

-----Original Message-----
From: "chris.gospels" <chris.gospels@yahoo.com>
Sender: AccessVBACentral@yahoogroups.com
Date: Wed, 08 Jun 2011 19:44:41
To: <AccessVBACentral@yahoogroups.com>
Reply-To: AccessVBACentral@yahoogroups.com
Subject: [Access VBA Central] Calculated Field Not Showing Values

Greetings All. I have a calculated field on a subform (continuous form) that fetches the stock balances of spares in a store using this code :=DLookUp("StockBal","qryStockBalance","MatCode=forms!frmMaterialsProfile!frmMaterialsProfileSub.form.MatCode"). On computers running Windows Vista, the values only show when I click on the calculated fields in the subform. However, on systems running Windows XP, the calculated field shows the stock balances for each item. I need assistance on this, please.

_Chris.



[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___