Accessing Data on Table

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

Hi

I have Access 2003 and my information does not appear in
table when entered via a form....Some data will appear
such as text with no formula attached...can anyone help?
 
Brett said:
Hi

I have Access 2003 and my information does not appear in
table when entered via a form....Some data will appear
such as text with no formula attached...can anyone help?
Click to expand...

Except in instances where history is important or processing is unusually
long, calculations are not stored in a relational database. This is because
they can always be recalculated. If you absolutely have to store them, you
need to push the data into a bound textbox or directly into a table using a
recordset. To push the data into a textbox, use some code similar to this in
each text box which is a part of the expression.

Sub MyText_AfterUpdate()
If Len(Me.[MyText2] & vbNullString) >0 And _
Len(Me.[MyText3] & vbNullString) >0 Then
Me.[MyText4] = Me.[MyText] + _
Me.[MyText2] + Me.[MyText3]
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top