textbox: counting & editing

[Dado]

I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?

[salad]

Dado wrote:

I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?

I really don't understand your question. If the textbox is a
calculation, you could enter something like
=[Text0] - [Text1]
or if you want to write a function then
=GetValue([ID])
or create a variable to store it in the declarations section of the code
module
Dim lngVal As Long
and when you save a record, store the value to lngVal. You can do stuff
in the OnCurrent event to stuff that value to the text field.

[Dado]

"salad" <oi*@vinegar.co m> je napisao u poruci interesnoj
grupi:%K******* *********@newsr ead3.news.atl.e arthlink.net...

Dado wrote:

I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?

I really don't understand your question. If the textbox is a calculation,
you could enter something like
=[Text0] - [Text1]
or if you want to write a function then
=GetValue([ID])
or create a variable to store it in the declarations section of the code
module
Dim lngVal As Long
and when you save a record, store the value to lngVal. You can do stuff
in the OnCurrent event to stuff that value to the text field.

I was thinking that it was be a nice that access counts me the fiield
(A+B=C),which I didn't insert. So if I insert A and C text field, that
access counts B field. I got counting C field but than i can't insert value
in it.

[salad]

Dado wrote:

"salad" <oi*@vinegar.co m> je napisao u poruci interesnoj
grupi:%K******* *********@newsr ead3.news.atl.e arthlink.net...

Dado wrote:

I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?

I really don't understand your question. If the textbox is a calculation,
you could enter something like
=[Text0] - [Text1]
or if you want to write a function then
=GetValue([ID])
or create a variable to store it in the declarations section of the code
module
Dim lngVal As Long
and when you save a record, store the value to lngVal. You can do stuff
in the OnCurrent event to stuff that value to the text field.

I was thinking that it was be a nice that access counts me the fiield
(A+B=C),which I didn't insert. So if I insert A and C text field, that
access counts B field. I got counting C field but than i can't insert value
in it.

I wish your English were better. I have a difficult time understanding
your problem. I don't know what A, B, C is representing... I don't know
if each are separate fields...I don't know what you mean by counting or
inserting. Do you have a friend that can write English that can
describe your problem for us? If yes, I'd start another post and see
what answers you get.

In the mean time, look at DCount(), Dlookup(), DSum(), etc. They may
meet some of your requirements.

[Dado]

"salad" <oi*@vinegar.co m> je napisao u poruci interesnoj
grupi:go******* **********@news read1.news.atl. earthlink.net.. .

Dado wrote:

"salad" <oi*@vinegar.co m> je napisao u poruci interesnoj
grupi:%K******* *********@newsr ead3.news.atl.e arthlink.net...

Dado wrote:
I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?

I really don't understand your question. If the textbox is a
calculatio n, you could enter something like
=[Text0] - [Text1]
or if you want to write a function then
=GetValue([ID])
or create a variable to store it in the declarations section of the code
module
Dim lngVal As Long
and when you save a record, store the value to lngVal. You can do stuff
in the OnCurrent event to stuff that value to the text field.

I was thinking that it was be a nice that access counts me the fiield
(A+B=C),which I didn't insert. So if I insert A and C text field, that
access counts B field. I got counting C field but than i can't insert
value in it.

I wish your English were better. I have a difficult time understanding
your problem. I don't know what A, B, C is representing... I don't know if
each are separate fields...I don't know what you mean by counting or
inserting. Do you have a friend that can write English that can describe
your problem for us? If yes, I'd start another post and see what answers
you get.

In the mean time, look at DCount(), Dlookup(), DSum(), etc. They may meet
some of your requirements.

A, B & C represents separate texbox fields which I tried to edit according
to a next formula:
A+B=C. But never mind and sorry about my English, I figure out that I must
put code in some event, not in a control source.
Thank you on DCount(), Dlookup(), DSum(),.