Display balance on subform

  • Thread starter Thread starter Peter Kinsman
  • Start date Start date
P

Peter Kinsman

I am trying to display a Stock Status report on a subform. The data comes
initially from a union query which combines Stocktake data, Receipts and
Issues. This is then sorted and the underlying query creates extra columns
for Receipts, Issues and Balance. I have added a dummy first record to
zeroise the Balance column.
When the subform is first displayed, it is correct, but if the screen is
scrolled, very strange things happen, like transactions being processed
twice.
Does anyone know whether this is possible in a datasheet subform - or do I
need to go to continuous forms displayed as a subform like I had to once
before?

Many thanks

Peter Kinsman
 
I have got round it by changing the underlying query to an append query,
using some VBA to update the Balance field and linking the subform to the
table. I have to add a Record-ID field to ensure that the file was
displayed in the same sequence as it had been updated.

Peter
 
Back
Top