Unbound data

[Aaron WOLSKI]

Hey all,

I have a form being displayed in datasheet view with a number of bound
fields. I want to be able to display an unbound field that is the result
of (qty * rate) fields.

If I try to place this result in the unbound field, every value in the
unbound column changes.

How do I specify a single row to change?

Cheers,

Aaron Wolski.

 

[Rick Brandt]

Hey all,

I have a form being displayed in datasheet view with a number of bound
fields. I want to be able to display an unbound field that is the result
of (qty * rate) fields.

If I try to place this result in the unbound field, every value in the
unbound column changes.

How do I specify a single row to change?

If the data source includes the fields [qty] and [rate] then you need to use a
ControlSource of...

=[qty]*[rate]

You can't do the calculation in code and make the assignment there.

 

[Wayne Morgan]

I just want to verify what you mean by "every value in the unbound column changes." Every
value in the unbound column should change to reflect the new equation, but have the
correct answer for the row it is in. Is this what is happening or are you getting the same
answer repeated in every row?

If the result is the first one, you have to think about what the datasheet view really is.
When you created the form, you only put one control on the form for that piece of data.
The datasheet view or the continuous form view takes that one set of controls and repeats
them several times down the screen, but it is still just the one set of controls.