Data Access page - Navigation

[OrangeEDC]

Good day folks:

I have a question that can be answered relatively quickly, but it may take a bit of explaining.

I created a database that identifies the following:
1. All Building Lots in a defined area
2. All Buildings on each lot
3. All Units in each building

The database works well and shows what I need to in terms of data.

I created the DAP shows:

First Section: Lot Data
Second Section: Unit Data

I use a Navigation Label that was created, which allows me to navigate between records. The problem is, there is "NO Text" on the Record Set Label when I view each unit.

However, when I view it in design view it does show the following: "Business Listings |0 of |2"

Example: Lot 1 has 1 building and 3 Units in that building.

Section 1 shows all the information specific to the lot.
Section 2 shows all the information specific to each unit and I use the Navigation label to navigate between units.

When I navigate between units, the lot data remains the same (It does not change, unless I use the Lot Navigation label to navigate to the next lot).

Thanks! I hope that explaing it well enough

 

[OrangeEDC]

Ack!

I forgot to tell you what I need.

I need to figure out how to show the text on the Record Set Navigation Level. What I expect it to show using the above example is, "Business 1 of 3"; "Business 2 of 3" and "Business 3 of 3" as I navigate through the three units.

Thanks again,

Paul

 

[OrangeEDC]

Good day all;

I tried posting my DB (zipped) to the forum to try and give you a better handle on my problem. But, It was to large. So I did the next best thing I could think of. I took a screen cap of the DAP and posted that, so you can get an idea of how this looks.

The top part of the page has the General property info and there are 182 records grouped by lot_id, the second part "Unit Data" shows all the individual (411) units associated with each Property. You will see the 2 Blue areas which are the naviation bars.

The top navigation bar bar navigates through each of the 177 records, while the bottom bar navigates through each of the 411 records. Some properties have 1 unit, while others have as many
as 12.

The two blue areas are suppose to identify how many records are associated with the current property.

The first nav label should say "Property 1 of 1" and the second should say "Unit Y of X", where Y = the current unit being viewed and X = the number of Units to be viewed.

I hope this helps. Thanks for any assistance. If anyone would like to see the Zip file it is only 312 KB and it is in Access 2002.

www.orangeedc.com/db.htm