Carry calculated value of a control from Form to Table

[JuneJ]

I have a Table which contains 3 fields:[ID],[Member],and[Ticket]. [ID] is an
Auto Number field and [Member] contains X00000 numbers which represents each
members. [Ticket] should be the conbination of two ([Ticket]=[Member]+[ID]).


For instance, if [ID]=1 and [Member]=100000, [Ticket] should be 100001.


I would like to put [Member] from a Form and would like values for [Ticket]
to appear automatically. I understand that Table cannot contain calculated
controls.

One solution I came up with is to use update query and run a macro to update
calculated values from the Query to the Table. It worked just fine but I
really hope that calculated value in the Form is carried out to the table
directly.

Is their any way to make it happen?

Thank you,

JuneJ

 

[Jeff Boyce]

June

The way to make it happen is to don't do it!

If you already have two fields which contain the pieces, use a query to
concatenate them for display in forms and reports.

There are a number of very good reasons NOT to store calculated values in
your tables, and only a very few good reason TO do it. We'd need to know
more about your situation before we could offer specific, informed
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Why do you have a need to store the same values a second time in your table?

Just run a query on the existing data each time it is needed for any reason.

 

[JuneJ via AccessMonster.com]

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

 

[Jeff Boyce]

June

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

Access is not a spreadsheet, 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]

Jeff,

Sounds like I'd better go with the safer way.

Thanks very much for your advise.

JuneJ

June

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

Access is not a spreadsheet, 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

Jeff and Karl,

[quoted text clipped - 16 lines]

JuneJ