How to get a DLookup control updated in a Group Header?

V

valy71

I have a report in Access 2007 with Grouping on BungalowNo and I am trying to
display the Name related to BungalowNo in the Group Header using DLookup.
However as the BungalowNo changes, the Name does not change.

How can I get the looked up value to change as the group value changes?
 
M

Marshall Barton

valy71 said:
I have a report in Access 2007 with Grouping on BungalowNo and I am trying to
display the Name related to BungalowNo in the Group Header using DLookup.
However as the BungalowNo changes, the Name does not change.

How can I get the looked up value to change as the group value changes?
Click to expand...

The DLookup should be along these lines:

=DLookup("BungalowName", "Bungalows", "BungalowNo=" &
Me.txtBungalowNo)
 
Top