Split form showing reference to individual cell in datasheet

[ian87]

Hi all,

I've successfully managed to do this in another database but it doesn't seem to be working in this one.

Basically I've been referencing certain cells in the top half of a split form so that i can show sub totals for higher categories.

To do this i have inserted loads of text boxes in the top half of my split form and referenced certain cells below with an iif statement based on the text that appears under a certain field.

I have five fields
Geography Process 2010-11 2011-12 2012-13
(filter field in combo)

Data in them is for example:
U.S. DM 3.0% 4.0% 5.0%
U.K. DC 4.5% 6.5% 7.5%

The Iif statement to reference the 2011-12 DM number is as follows:
=Nz(Iif([Process]="DM",[2011-12],0),0)

The formula works but only shows the data in the top half when i click on the related record in the datasheet in the bottom half of the split form.

When i have done this before, the text boxes with iif statements in the top half reference the data in the cells regardless of which record i am editing in the datasheet cell.

Any help would be much appreciated,

Ian

 

[Galaxiom]

Split forms are an odd concoction. They are a very simple way for beginners to get a good outcome on a basic form task. However they are not built to do complex things and there are many weaknesses mostly due to the inability to separately reference the two parts of the form.

My advice would be change the design to work with subforms and avoid using split forms entirely.

 

[spikepl]

#2 I fully agree. Split forms seem a simple shortcut to lots of functionality, but sooner or later you'll run into unexpected "features". My last 3 solutions were with split forms, and each and one provided time-consuming "features".

 

[Galaxiom]

Split forms seem a simple shortcut to lots of functionality, but sooner or later you'll run into unexpected "features".

AKA "defeat-ya"