Storing a "Calculated" field.

[fatmcgav]

Hey there,

I want to store a "calculated" value from a form text-box. By calculated, i simply mean that it is a textbox that contains the following Data:

=[MemberFirstName] & [MemberLastName]

Basically, the field is the Members Username, the text box is called "Username" and it needs to be stored in "tblMemberInfo" under "MemberLogin" so that it can be used externally for the website.
The value is only going to be calculated automatically by the form once, and then it wont need to be changed again, which is why i want to store it in the db.

Any ideas on how i'd go about doing this?

Cheers
Fatmcgav

 

[Crispy]

There are many valid reasons why it's not good practice to write a calculated field back into a table. An alternative would be to query the table to include an expression which is

UseName: [MemberFirstName] & [MemberLastName]

However if you decide to store the field in the table, then put an action in the AfterUpdate event of your form to say

me!UserName = me![MemberFirstName] & me![MemberLastName]

which should do what you require.

 

[Pat Hartman]

then put an action in the AfterUpdate event of your form

The AfterUpdate event fires AFTER the record is saved. You need to put the code in the form's BeforeUpdate event so that it will be saved with the record.