Continuous forms

[Nick T]

Hi,
Got a form which the default view is set to 'continous forms'. this form
gets its data from a query and needs to be displayed like this.
I have 2 fields on the form which the data is provided by the query - these
being 'Actual weight' and 'Target Weight' (this data appears in text boxes).
I have a 3rd text box, which i want to apply a calculation to such as
'Target Weight' minus 'Actual Weight'. This will give me the difference
between the two.
However, if i add this to any command on the form, such as:

Eg,
On open,
Me.Difference = Me.Target - Me.Actual

The code works, and gives me the right answer to this calculation, however
because it is a continous form, the 'first' records calculation answer is
detailed in every text box labelled 'Difference' (even though they are on
different records on the form). Any suggestions anyone??

Thanks

 

[Mr. B]

Nick T,

Try adding your calculation to your query.

HTH
Mr. B
askdoctoraccess dot com

 

[Nick T]

Hi,
Can you elaborate a little (beginner here)!

If i go to the desigh view of my query, where would i put this calculation??
In a new Column??
In what row??

Hope to hear back.

Thanks

 

[Mr. B]

Nick T,

Sorry. I just didn't think about that.

Yes, in a new column put something like:

WeightDiff: ['Target weight] - [Actual Weight]

HTH
Mr. B
askdoctoraccess dot com

 

[Clifford Bass]

Hi Nick,

Create an unbound text box on your form and set its Control Source
property to:

=[Target] - [Actual]

If either field can be null you could do something like this:

=IIf(IsNull([Target]) or IsNull([Actual]), "Unknown", [Target] - [Actual])

Hope that helps,

Clifford Bass