N
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
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