Re: Carry calculated value of a control from Form to Table

June

You may be confusing what you see with what is stored in the table.

Access is not a spread***, so you are not limited to what you store.
Tables store data, forms display it.

Use a query to concatenate the fields for use in a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"JuneJ via AccessMonster.com" <u44883@uwe> wrote in message
news:8748b6b159852@xxxxxx
Jeff and Karl,

Thank you for your help!

The table is to store claim data, and each member who files a claim have
unique ID, which is [Member]. [ID] represents unique Number for a claim.
[Ticket] is to identify who claimed and and number for the claim at the
same
time.

My intention is that each time when a member files a claim from Form,
correct
[Ticket] number would appear on the table so that they can reduce an extra
process. It would be even better if I could take [ID] and [Member] out
from
the table and [Ticket] would only appear.

Would it help?

JuneJ

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200807/1



.