Setting calculated field equal to calculated value

[Guest]

I don't know how to express this properly I'm afraid... therefore I'm having
a tough time searching for the answer.

[txtAmendReq] Control Source is:

=IIf(Abs([txtDifference])>5,"Yes","No")

After I enter the values necessary to calculate the [txtDifference] field,
[txtAmendReq] is displaying "Yes" or "No" properly, however, looking through
the table, I note that [txtAmendReq] is not being updated with "Yes" or "No",
it's empty. I want to store either "Yes" or "Not", or 1 or 0, in the table.
How can I do this?

TIA

 

[[MVP] S.Clark]

Create a Yes/No field in the table
Add a checkbox to the form, based on this new field.. Hide it if you want.
In the AfterUpdate of txtDifference, set the value of the checkbox.

chkAmendReq = (txtDifference > 5)

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Jeff Boyce]

Ricter

Where are you trying to do this? If you are working in a query, you can use
expressions like this.

If you are working in a table, you cannot do this -- Access doesn't have
triggers for its tables.

If you are working in a form, and trying to set the value of a text control
on the form, what event has to happen for this setting to be fired?

More info, please...

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve Schapel]

Ricter,

Well, there are ways to write values from unbound form controls into a
table, using macro or VBA procedure. But, can you say why you want to
store the "Yes" or "No" in the table? This would normally be regarded
as an invalid database design choice. You probably should not even have
the txtAmendReq field in the table at all, and I would suggest you solve
the probelm by deleting the field. It is a calculated or derived value,
and as such you can calculate or derive it whenever you need it.

 

[Guest]

Thank you all, 'preciate it. Steve, you're right, I forgot about that db
design norm with this calculated field. I can indeed produce the query I
need for all those records where the abs > 5, without ever storing it.

Ricter,

Well, there are ways to write values from unbound form controls into a
table, using macro or VBA procedure. But, can you say why you want to
store the "Yes" or "No" in the table? This would normally be regarded
as an invalid database design choice. You probably should not even have
the txtAmendReq field in the table at all, and I would suggest you solve
the probelm by deleting the field. It is a calculated or derived value,
and as such you can calculate or derive it whenever you need it.

--
Steve Schapel, Microsoft Access MVP

I don't know how to express this properly I'm afraid... therefore I'm having
a tough time searching for the answer.

[txtAmendReq] Control Source is:

=IIf(Abs([txtDifference])>5,"Yes","No")

After I enter the values necessary to calculate the [txtDifference] field,
[txtAmendReq] is displaying "Yes" or "No" properly, however, looking through
the table, I note that [txtAmendReq] is not being updated with "Yes" or "No",
it's empty. I want to store either "Yes" or "Not", or 1 or 0, in the table.
How can I do this?

TIA